What is a file with extension XLK?

Tuesday, April 3, 2012 by Tan
I was working on MS Access and had to export a table to an excel workbook. This happened nice and fast. Then, I opened the workbook and made some changes and when I closed the workbook, I found another file in that folder. See below:

This is something new to me. The new file created was of the same size as the original size and it said that it’s a backup file. I did not want that to happen and so, I searched and found out things about XLK files.

The backup file that was created was an XLK file. XLK file extensions are associated with MS Excel and not MS Access, as I initially thought. These files are used to create backups of the normal XLS or XLSX files. These backup files carry the data and formatting that the originals had just before they were saved for the first time.

It is not easy to create such files in MS Excel as this option is not a default one. However, when a new excel workbook is created from MS Access, the file is saved with an optioned enabled, which creates backups automatically when it is saved.

Now, how to create a MS Excel workbook which will keep on taking backups? Here is it, for computers running MS Office 2007.

We need to save the file once more, this time, choose ‘Save As…’ option, instead of a simple Save. When you have the ‘Save As…’ dialog box open, click on the small down arrow in the Tools button and choose ‘General Options.’

In the new window that appears, check the option ‘Always create backup’ to enable automatic backing up of your MS Excel file.

Now, when you open this file, make some changes and save it, the backup file, with the XLK extension will automatically be created. However, this option does not change how your MS Excel behaves, but is specific to that one file, in which you have enabled this option.

If you have MS Office 2003 installed in your computer and you want it to create similar XLK files when you save them, click on File, go to ‘Save As…’ and then go to Tools and finally you will find ‘General Options’ present in there, where you can check the ‘Always create backup’ checkbox.

While searching, I landed up in a website, which felt nice. It started with saying:
Backup your files, always take backups Three things are certain: Death, taxes, and lost data. You can put them off but you can’t eliminate them. The only difference between a good hard drive and a bad hard drive, is that the good hard drive hasn't crashed yet.

Check this out. They talk about the advantages of backing up your data.

Posted in Labels: , , | 0 Comments »

0 Reviews: