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

Brovashift

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
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 o_O
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Brovashift

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
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! :rolleyes:

Excel capture.JPG
 

Brovashift

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
Also; there should really be an Edit button on these posts.
 

petertenthije

Active Member
Joined
Sep 25, 2012
Messages
287

ADVERTISEMENT

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

Well-known Member
Joined
Oct 27, 2005
Messages
21,177
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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

Active Member
Joined
Sep 25, 2012
Messages
287

ADVERTISEMENT

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

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
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:
error.JPG


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

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
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

New Member
Joined
May 9, 2021
Messages
13
Office Version
  1. 2007
Platform
  1. Windows
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."
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,767
Messages
5,766,359
Members
425,350
Latest member
procha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top