Backing up files ensure that your data is protected against data corruption, permanent deletion, or hardware failure. MS Excel provides an inbuilt backup feature which create another copy of Excel file and get updated each time you save your original Workbook. In this blog, I will elaborate how to backup Excel file automatically in easy steps using manual method.
Step 1: Go to Save As > Computer > Browse the location where you want to save original and backup copy of Excel file.
Step 2: In the Save As dialogue box, click on the arrow next to the Tools button. Then go to General Options as shown in below figure.
Step 3: After selecting General Options, a new pop up Window will appear. Check Always create backup checkbox and if you want your Excel file as well as backup copy to be protected then type password.
Once backup copy has been created, you can view Excel backup file with .XLK extension and original Excel file with .XLSX extension in a user-defined location.
When the above procedure i.e. how to backup Excel file automatically is completed then it will be easier to access corrupt or deleted .XLS or .XLSX file data using backup copy of Workbook (.XLK). But what if both the files i.e. original and backup file become inaccessible due to virus infection or hard drive corruption. Then there is no way to recover data from hard drive other than professionally built software such as Windows data recovery software which quickly recover data including corrupt or deleted Excel files, images, videos, documents etc.
Conclusion: The above blog elaborated how to backup excel file automatically using inbuilt feature of MS Excel. This remarkable feature is used in recovery process of Excel Workbooks when there is a data loss or data corruption situation occurs. This is the best solution for accessing the healthy copy of their corrupt or lost original Excel file.
Steps to Backup Excel File automatically
If for some reason, MS Excel file got corrupt or deleted permanently, you can still have access your data from backup copy of a Workbook. Follow the below steps to use Backup feature of MS Excel 2013.
Step 1: Go to Save As > Computer > Browse the location where you want to save original and backup copy of Excel file.
Step 2: In the Save As dialogue box, click on the arrow next to the Tools button. Then go to General Options as shown in below figure.
Step 3: After selecting General Options, a new pop up Window will appear. Check Always create backup checkbox and if you want your Excel file as well as backup copy to be protected then type password.
Once backup copy has been created, you can view Excel backup file with .XLK extension and original Excel file with .XLSX extension in a user-defined location.
Recover Excel Files with .XLSX or .XLK extension
When the above procedure i.e. how to backup Excel file automatically is completed then it will be easier to access corrupt or deleted .XLS or .XLSX file data using backup copy of Workbook (.XLK). But what if both the files i.e. original and backup file become inaccessible due to virus infection or hard drive corruption. Then there is no way to recover data from hard drive other than professionally built software such as Windows data recovery software which quickly recover data including corrupt or deleted Excel files, images, videos, documents etc.
Conclusion: The above blog elaborated how to backup excel file automatically using inbuilt feature of MS Excel. This remarkable feature is used in recovery process of Excel Workbooks when there is a data loss or data corruption situation occurs. This is the best solution for accessing the healthy copy of their corrupt or lost original Excel file.
No comments:
Post a Comment