View auto back-up files

[Guest]

Where does Windows stash the files that are automatically "backed-up"? There seems to be no trace in My documents

Thanks

 

[Norman Harker]

Hi Philly!

If you backup under the same name, that is what the backup is called.
It doesn't so much backup as over-save.

That's probably the main advantage of Jan's AutoSafe Addin.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Where does Windows stash the files that are automatically

"backed-up"? There seems to be no trace in My documents.

 

[Gord Dibben]

Philly

Three different types of "backup".

1. AutoSave, which does not backup, but overwrites the file at preset
intervals.

2. AutoRecovery, which saves a backup at preset intervals, but dumps that
backup if Excel and file close without incident.'

3. "Always create backup" in the File>Save As>Tools>Options section which
will save a backup as an *.XLK file when you save the file.

With the exception of AutoSave, none of these will be of any help with
recovering the data you lost when you clicked "No" to save these changes.

Gord Dibben Excel MVP