Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I retrieve changes to an unsaved excel document
I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
an excel doc without saving changes thinking I was closing the earlier version of the doc. Needless to say I was terribly disapointed to find I closed the wrong version of the doc. Is there any way to retrieve the doc with the changes made to it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I retrieve changes to an unsaved excel document
No. Sorry.
BrianH "Jim" wrote: I am using WinXP home edition and Excel in Office 2000. I inadvertly closed an excel doc without saving changes thinking I was closing the earlier version of the doc. Needless to say I was terribly disapointed to find I closed the wrong version of the doc. Is there any way to retrieve the doc with the changes made to it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I retrieve changes to an unsaved excel document
Nope.
If you never saved it, all the changes are gone. Jim wrote: I am using WinXP home edition and Excel in Office 2000. I inadvertly closed an excel doc without saving changes thinking I was closing the earlier version of the doc. Needless to say I was terribly disapointed to find I closed the wrong version of the doc. Is there any way to retrieve the doc with the changes made to it. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I retrieve changes to an unsaved excel document
For clarification, what if it was an existing file? I modified it, but never
saved about two hours worth of work. My autorecovery interval is set to every 10 minutes. Why are there no recovery files in the folder for this interval of time? "Dave Peterson" wrote: Nope. If you never saved it, all the changes are gone. Jim wrote: I am using WinXP home edition and Excel in Office 2000. I inadvertly closed an excel doc without saving changes thinking I was closing the earlier version of the doc. Needless to say I was terribly disapointed to find I closed the wrong version of the doc. Is there any way to retrieve the doc with the changes made to it. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I retrieve changes to an unsaved excel document
Saved from a previous post:
xl2k and below came with an optional addin called AutoSave.xla. It could be set to save every x minutes (user selectable). And it just saves the file at those intervals. xl2002+ comes with something called autorecovery. It's also optional, but if the user turns it on, it saves a copy of that workbook in a special location (also user selectable). If windows or excel crashes, then the next time excel opens, it notices that there's a file in that location. Excel prompts the user to see if he/she wants to recover that file that was saved when excel/windows crashed. This autorecovery feature isn't used for the same purpose as AutoSave. You may be interested in an addin that Jan Karel Pieterse (works in any version) called AutoSafe (note spelling). 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, not autosafeVBE.zip, for your purposes.) If you really want autosave... Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm JC Stokoe wrote: For clarification, what if it was an existing file? I modified it, but never saved about two hours worth of work. My autorecovery interval is set to every 10 minutes. Why are there no recovery files in the folder for this interval of time? "Dave Peterson" wrote: Nope. If you never saved it, all the changes are gone. Jim wrote: I am using WinXP home edition and Excel in Office 2000. I inadvertly closed an excel doc without saving changes thinking I was closing the earlier version of the doc. Needless to say I was terribly disapointed to find I closed the wrong version of the doc. Is there any way to retrieve the doc with the changes made to it. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a word document into an excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I reduce the file size of an Excel document? | Excel Discussion (Misc queries) | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) |