Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto create "backup of filename.xls" in Excel 2007.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto create "backup of filename.xls" in Excel 2007.
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 ButtonSave AsToolsGeneral Options and tickmark "Always create backup" Gord Dibben MS Excel MVP On Fri, 6 Nov 2009 14:11:02 -0800, waykwabu wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto create "backup of filename.xls" in Excel 2007.
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. "Gord Dibben" wrote: 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 ButtonSave AsToolsGeneral Options and tickmark "Always create backup" Gord Dibben MS Excel MVP On Fri, 6 Nov 2009 14:11:02 -0800, waykwabu wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Taskbar Tab shows Icon + "Microsoft Excel - filename" | Excel Discussion (Misc queries) | |||
2007 Need macro to auto set option buttons all to "Yes" or "No" | Excel Worksheet Functions | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Is there a "create List dialog box" in Excel 2007 ? | New Users to Excel | |||
Is there a way to create a "flag" in Excel 2007? | Excel Discussion (Misc queries) |