How to Create Backup File Dynamically for MS Excel


Create New Folder at Desktop and save folder as " excel_autobackup_utility".

Start MS Office --> MS Excel --> New

Excel1.gif

Data entry in Excel file… Click for Save…. Dialer Box will come there

Excel2.gif

Typed File name as status.xlsx and click at Tools button then General Option

Excel3.gif

After Clicking on General Option…General Options Dialer Box will shown as...

Excel4.gif

Now just check in box 'Always create backup'

Excel5.gif

And finally Click on Save button.

Excel6.gif

Now check at Desktop\ excel_autobackup_utility folder

Excel7.gif

Backup of STATUS.xlsx file has been created which data will restore dynamically of Status.xlsx file.

After deleting STATUS.xlsx file; 'Backup of STATUS.xlk' file help to you save data.


Similar Articles