Excel 2007 .xlk file - why is it created?

[Tony]

Can anyone tell me why Excel 2007 will sometimes create a backup file, on
its own, with a .xlk extension? I've searched Excel help, the Internet, and
MS's site, but can't find any info. I'm interested to know under what
circumstances these files are created, because the behavior seems a bit
random to me.

Thanks

 

[Bob I]

Not random at all. A backup file is created when that option is set for
the file in question. It is set on the file itself.

See, Save As, Tools, General Options, Always create backup.

 

[Tony]

Bob,

Thanks for the response - I found the option exactly as you pointed out. As
it turns out, the spreadsheets where I see this behavior are exports from
Access 2007, which apparently checks this option for its exports. An
'enhancement' I could do without. I dug around in the guts of Access to see
if I could suppress this, but did not find an option to do so.

Thanks again for the reply. It's nice to know that I'm not going crazy...

Ciao

 

[Bob I]

You're welcome, I don't know of a way to "suppress" that export setting
unless you use a 2 steps say to text and then import that file in Excel.

 

[Tony]

I couldn't find a way to do it, but not a big deal. Just as easy to turn
off the setting in the resultant spreadsheet. Not necessarily a bad thing,
particularly if rolling a database out to end users, but it would be a lot
better if it could be toggled on/off.

Thanks again for the assist.

 

[Bob I]

I suppose you could record a macro to turn it off and run that after you
open the exported file.