How to auto create "backup of filename.xls" in Excel 2007.

[waykwabu]

I do not seem to be able to auto create a file "backup of filename.xls" in
Excel 2007 like I could in previous version. This backup file was the "old"
file when opened prior to any changes and subsequent saving.
Have followed the Help Line (F1) instructions re auto saving, set to 3 mins
but I still do not see the "backup" file created in the relevant fold
alongside the newly saved file.

 

[Gord Dibben]

You misunderstand the purpose of the "autosaving".

In Excel 2002 and since, a true autosave was abandoned in favor of
"autorecovery" which does nothing more than create a timed temporary copy of
the workbook while it is open.

When the workbook and Excel are successfully closed, the temporary is
deleted. No backup is saved.

If you want a backup created each time you save the workbook you must go to
Button>Save As>Tools>General Options and tickmark "Always create backup"


Gord Dibben MS Excel MVP

 

[waykwabu]

Thankyou for that clarification - I have now located it. At the office we
have only just now upgraded to Vista ( and Windows 7 is now out !!) and
Office 2007 as prior to now our accounting and human resources software was
incompatible with Vista.
Thankyou sincerely for your advice.