If you open the Excel backup file, you may be prompted to confirm you want to open the file.
And then, if you need to, you could actually open up this backup file which would reflect the changes prior to the last time the file was saved. Although the extension makes it a little bit easier to locate the backup file, it should be easy for you to find the file because they are named differently. If you’re not seeing the file extension from Windows Explorer, choose the View tab in the Ribbon and then select File name extensions. XLK extension and “Backup of” and then the file name. The AutoBackup updates the backup copy automatically, and so it’s up to date and one version behind the original, and other users don’t even need to know about the file. Basically, the backup file is always one version behind the current version. The third time you save it, however, the backup file will be updated with information up to the second save. If you make edits to the original file and then save it again, the backup file will still remain the same (the original data). Note that the first time you save, the files will be exactly the same. XLK extension and is stored in the same location as the original. Now, every time you make a change in the original spreadsheet and save it, the Excel backup file is updated to reflect your spreadsheet before that last save. Check the box next to “ Always create backup“.Choose the Tools button then General Options in the Save As dialog window.Click “ More options…” under the save location.With the file open, choose File > Save As.
Follow these steps to set up an automatic backup for your key Excel workbooks:
0 kommentar(er)
