Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving worksheets - Office 2003
hi
Is there a way to create backup copies of Excel worksheets, like you can in Word? I've just lost the last ten minutes of a worksheet and it wouldhave been really useful to have some kind of back up plan. Any help would be really appreciated. -- Many thanks JD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving worksheets - Office 2003
Tools Options Save and check autosave
-- Gary's Student "Jackie D" wrote: hi Is there a way to create backup copies of Excel worksheets, like you can in Word? I've just lost the last ten minutes of a worksheet and it wouldhave been really useful to have some kind of back up plan. Any help would be really appreciated. -- Many thanks JD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving worksheets - Office 2003
Hi Gary. I had that checked already and I was selecting save every 30
seconds. A crash caused it. I've found a macro called AutoSafe but I'm having dificulty getting it to work -- Many thanks JD "Gary''s Student" wrote: Tools Options Save and check autosave -- Gary's Student "Jackie D" wrote: hi Is there a way to create backup copies of Excel worksheets, like you can in Word? I've just lost the last ten minutes of a worksheet and it wouldhave been really useful to have some kind of back up plan. Any help would be really appreciated. -- Many thanks JD |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
saving worksheets - Office 2003
Jackie
As you have found out, there is no Autosave in XL2002 and 2003 as there was in earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 in 2002 and 2003 and it does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip) Gord Dibben Excel MVP On Sun, 20 Nov 2005 04:38:02 -0800, "Jackie D" wrote: hi Is there a way to create backup copies of Excel worksheets, like you can in Word? I've just lost the last ten minutes of a worksheet and it wouldhave been really useful to have some kind of back up plan. Any help would be really appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003. | Excel Worksheet Functions | |||
Office 2003 Purchaser can't add in the add in's. Why? | Excel Worksheet Functions | |||
Do I need Office 2003 to download templates ? Have Office 2000. | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
How to use the template wizard with office 2003 | Excel Discussion (Misc queries) |