All todays data has disappeared! :( PLEASE HELP!!!

[Brovashift]

Hi all,

I am praying to god that someone here can please help me... I have been working on a project in Excel (office 2007) and have been working on it all day today, was literally finished, just one more formula for the last cell and I was done.

I tired to open up another excel project by starting a new excel program, like I have done before, in order to see how a particular formula had been written in there, and other projects seemed to crash. I dialog box did pop up but I didn't read it and just hit OK. But now all the work I have done today had disappeared, and there was a lot! Also the completed project that I was trying to open up has also lost part of its data as well. I don't understand what has happened, because I have also got Auto Save checked in the options, set to every 10mins.

I am praying that those auto saves are somewhere on my computer. I am using windows 10.

I am hoping one of you excel experts can save me, before my acid reflux kills me! lol

Thank you in advance

 

[Logit]

I once read an article that described the following scenario:

While working with Excel, you click save and think that your work is saved. Then, a breaker is tripped or a blackout comes. When things go back to normal, you open Excel trying to get back to where you were. Surprise! Your work is not saved. There is a lag between when you click to save and when Excel actually saves the work. If you lose power in between, the work is not saved.

The article said Microsoft would rectify the problem. Not sure if they have done it. My pc is always on a UPS.

I make a "backup copy" of the entire workbook naming it with date and time. Then I check to verify the backup copy was complete.

If the power goes out while I am doing that, the worse case scenario is I've lost maybe 30 minutes of work. I work slow, so there wouldn't be much to rebuild.