Create a Sample File and a Backup
To begin this demonstration, open Microsoft Excel and then create some sample data. We just used random numbers and letters so we have something to work with.
Next, click the Office button and then click the "Save As" button that is displayed in the options list
In the Excel Options window that pops up, click the Save option in the left hand column.
Next, in the Save As window, type a file name in the File Name field (in this example we use "this is a test file" for the name) and then click the Tools button to the left of the Save button.
Click the General Options selection on the drop down menu. Click the Always create backup check box and then click the OK button.
Now, click the Save button on the Save As dialog. Your file will be saved and you can continue working. Change the data on your spreadsheet.
Save the file by pressing <Control><S> and then close it by pressing <Control><F4>. You now should have a backup of the original file in the form of an "xlk" file. Next, find the file using Windows Explorer by browsing to the folder where the original file is. You should now have a file called "Backup of [your file name].xlk". In this example situation, we have a file called "Backup of this is a test file.xlk" that was created.
Now let's see how to open the backup file.