Is there a way of retrieving a previous version of an excel docume

[NancyDrew]

Help! I've been working on an excel sheet for a few hours and as I was
entering a formula, I rec'd an error message that stated that Excel would be
closed down. Now when I open the document it is the old version (before the
hours of work). Is there a way to retrieve the most recent version?

Any help would be appreciated!

 

[davo]

did you perform a save during those hours of work?
I am in the habit of hitting 'ctrl + s' (= save) every few minutes just in
case of such a crash, whatever the application.
If you're uncertain about saving your work frequently because you think
there's a slim chance you might want to go back, then do 'save as..' and
append the filename with a date or time or an a or b or c or something that
you can later remove to restore the proper filename when you've finshed the
job. Another benefit of this practice is that if a file gets damaged and
cant be opened or if you accidentally delete a whole lot of stuff from it,
then you have a previous version to go back to or to cut and paste from.
I am sorry I dont know the details of excel to answer whether you can
retrieve your work- this is just general advice to avoid what happened