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]

Excel 2007 Tip: Automatically saving Excel files and finding saved files

 

[Brovashift]

Excel 2007 Tip: Automatically saving Excel files and finding saved files

Hi, thanks for the link... but unfortunately I have tried that and there is nothing in my; C:\Users\MYCOMPUTER\AppData\Roaming\Microsoft\Excel\

Could there be anything in my server drafts location on my computer... and do you know where I can find this location? I've looked in E:\ but there is no folder named "SharePoint Drafts", and as I haven't got "web server" selected I'm guessing it wont be there anyway. I have the document, with all worked saved up until last night, but all my work today has vanished. I have got Auto Save selected and set to every 10mins, but if I can find any drafts it's like that feature hasn't been working!

 

[Brovashift]

Also; there should really be an Edit button on these posts.

 

[petertenthije]

Maybe the folder “E:\C documents\sharepoint drafts\“ is set to hidden? Copy the path and paste it in your windows explorer to directly go there.

 

[Michael M]

There is an Edit button on ALL posts but can only be edited up to 10 minutes after it's posted !
Also, try
File Explorer has a convenient way to search recently modified files built right into the “Search” tab on the Ribbon.
Switch to the “Search” tab, click the “Date Modified” button, and then select a range.
If you don't see the “Search” tab, click once in the search box and it should appear

 

[petertenthije]

Also, right mouse click on your file from yesterday, and check if you have the option to restore old versions. Depending on your settings windows will make a backup every few hours.

 

[Brovashift]

Maybe the folder “E:\C documents\sharepoint drafts\“ is set to hidden? Copy the path and paste it in your windows explorer to directly go there.

Thanks, I tried that but it just says Windows cannot find it:

I am looking in the ....AppData\Local\Temp folder now, but nothing is named, it's all in hexadecimal format.

I've got a feeling I am going to have a busy Monday redoing all my work.

 

[Brovashift]

There is an Edit button on ALL posts but can only be edited up to 10 minutes after it's posted !
Also, try
File Explorer has a convenient way to search recently modified files built right into the “Search” tab on the Ribbon.
Switch to the “Search” tab, click the “Date Modified” button, and then select a range.
If you don't see the “Search” tab, click once in the search box and it should appear

I try and edit straight away. Where should the edit button be located, bottom right with "quote" and "reply"?

 

[Brovashift]

Also, right mouse click on your file from yesterday, and check if you have the option to restore old versions. Depending on your settings windows will make a backup every few hours.

Oh wow, I didn't know about that... but unfortunately there is nothing there! Says "previous versions come from file history or from restore points."