Pin Me

Discover the Power of Saving and Opening with Excel XLK backups

written by: Bruce Tyson•edited by: Tricia Goss•updated: 6/14/2010

The Microsoft Excel recovery feature allows users to automatically create backups of their work when saving a spreadsheet file. By using this functionality, you can be assured that you have the backup file name extension Microsoft Excel xlk available to restore your work.

  • slide 1 of 3

    Getting Started

    To use the backup file name extension in Microsoft Excel (xlk), you will need to have Microsoft Office Excel installed on a computer meeting the minimum system requirements of Microsoft Office. This Microsoft Excel tutorial assumes you know how to start the Microsoft Excel program and are reasonably familiar with its interface.

  • slide 2 of 3

    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.

    Enter Data into Microsoft Excel 

    Next, click the Office button and then click the "Save As" button that is displayed in the options list

    Excel Save As 

    In the Excel Options window that pops up, click the Save option in the left hand column.

    Excel Options Button 

    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.

    Excel Tools Button Click the General Options selection on the drop down menu. Click the Always create backup check box and then click the OK button.

    Excel General Options 

    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.

    Excel Data 

    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.

    Excel Backup File 

    Now let's see how to open the backup file.

  • slide 3 of 3

    Open the Backup File

    Using Windows Explorer, browse to the xlk file and double click the file name. you will see a dialog box appear that says:

    "The file you are trying to open, 'Backup of [Your File Name].xlk', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

    Open Excel Backup File Click the Yes button and you will see your original data appear in Microsoft Excel. You can now save the file in Excel format by clicking the Office button and then choosing Save As.

    Excel Original Data Now Restored 

    You now know how the backup file name extension Microsoft Excel xlk works. You can set files to backup automatically every time they are saved and you can open the backup files and save them in regular Excel format.

More To Explore