Can I reverse a saved file to the previous file in Excel?

[Guest]

I made some changes to a spread sheet that were wrong and then saved the file
and would like to be able to go back to the previous version of this file.
Is that possible?

 

[David Biddulph]

It is if you saved a backup. The option for "Always save a backup" is
available under File/ Save As/ Options.

 

[Peo Sjoblom]

Not unless you have another copy, for instance if you have sent or received
the file via email prior to the latest change you did and you can go to your
email and pull that copy. In the 2007 version I believe you can undo if you
haven't closed the file after saving but in earlier versions it is not
possible

 

[Guest]

Hi,

Caution: The moment you notice that the previous version of the file is
important, do no save the current file again.

Important:

You can get back to your previous saved verison only if you have done the
following;

1. On the Tools menu, click Options,
2. Click the Save tab.
3. Verify that you have selected the "Save AutoRecover info every" list box,
and then if you typed a number value or you have the arrow to the right of
the "Save AutoRecover info every" list. You can increase or decrease the
value by clicking the up or down arrow key.
4. Save the path for the autorecovery in the AutoRecover save location text
path.
5. Under the Workbook option, verify that the Disable AutoRecover checkbox
is cleared.
6. Click OK to save the settings and return to the worksheet.

Otherwise, you will loose the previous backup file.

Note: This is just an assumption. If you have emailed any of the previous
backup file to anyone, then you can request them to send back that copy to
you. This help you modify the cahnges you require in your workbook.

Challa Prabhu

 

[David Biddulph]

Am I confused?

I thought that the AutoRecover option was to do an automatic save to avoid
losing information that *hasn't* been saved manually (to cope with
situations like power failures). I thought from
http://support.microsoft.com/kb/289273 that the AutoRecover data was cleared
when a manual save is done.

My understanding is that what was needed to cover the OP's situation is
*not* the AutoRecover option but the option for "Always create backup". Did
I misunderstand?

 

[Peo Sjoblom]

No you are correct, autorecovery is not a backup per see, it protects you
against crashes but once you successfully save a workbook autorecovery will
not keep a backup copy of a previously saved file. If you select always
create backup in the save as dialogue box it will save a copy of the
previously saved file so unless the OP worked on the file and saved twice
this would have helped her