View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Is there a way to revert to a previous save in Excel?

Yep. If you can't find a backup copy, that data is gone.

One of the things I do when I know I'm making significant changes is:
file|open
select my file in the dialog
click on the dropdown arrow on the Open button
and open the file in Readonly mode.

That way I can't overwrite my original workbook (well, without doing a bunch of
junk).

I sometimes save files with names like:

book1_2006_07_25.xls

And if I'm making lots of changes and really scared I'll mess it up, I'll even
have files that look like:

book1_2006_07_25__09_58.xls
later
book1_2006_07_25__14_33.xls


Yes, I can have lots of clutter in those folders--but it's saved me a few
times--and it's pretty easy to clean up that clutter when I know that everything
is ok.

(Disk space is cheap. Your time is expensive.)



JoelP wrote:

i have the exact same problem just now, accidentally pressed the save key at
the wrong time and lost almost all of my work. since none of the conditions
you set below apply to me, doe it mean i have lost all that data forever?

"Dave Peterson" wrote:

Do you have a backup version?

Did you email someone a copy (check your sent folder or ask for a copy back)?

Was it stored on a network drive? Get your IT staff to restore from a backup
tape?

Is there a copy in the recycle bin?



Laura wrote:

Is it possible to restore a spreadsheet that was accidentally overwritten?


--

Dave Peterson


--

Dave Peterson