Document Recovery ( AutoRecover ) is not working for Excel 2016. System: Windows 8.1 64 bit Microsoft Excel 2016 MSO (16.0.8528.2126) 64 bit No fix even after a full Online repair of Office 2016 and, of course, all possible Office Updates. After working for hours on several Excel documents (which had previously been saved with a file name etc.), the power went out in our building. When the power was restored and Excel reopened, I was presented with the expected list of Recovered Documents on the left side. HOWEVER, every single one of these were simply "the Original version" or "the version last saved by user" (something like that). Meaning they did not contain ANY new data that had been entered since the last time I had saved them/reopened them despite the AutoRecover being set to 1 minute. NOTES : Document Recovery seems to be working for Word and PP. The settings in Options>Save are all the same for all Office products: currently set to AutoRecover every 1 minute. The ...AppData>Roaming>Microsoft>Excel folder contains no backup file/folder for new or reopened Excel Documents. Thank goodness, the AutoRecover does seem to be updating the equivalent folder for Word ("AutoRecovery save of DocumentX.asd" files get updated) and PowerPoint (the "pptXXX.tmp" file also updated). Edit: This is obviously some MSOffice Bug. Of the multiple 'test' spreadsheets I've been playing around with to study this, exactly 1 of them seems to actually back up. But absolutely no other ones and none of my previously created sheets ever backup to AutoRecover.

'autosave' and 'autorecover' are different features right?

Same problem, checkboxes correct, has happened twice. It appears that Microsoft no longer supports autosave unless the file has already been saved to one of their cloud locations. "If you have Office 2016 with an Office 365 Subscription you should have the AutoSave feature which automatically saves what you're working on in real time as long as the file you're working on is saved to OneDrive or SharePoint." "This file location doesn't support AutoSave. Save to OneDrive or SharePoint Online if you want to use AutoSave." This would be more palatable if they did it more transparently, but they seem to be letting people lose their data by not warning them that the autosave feature is otherwise disabled. How about this: "Saving to a non-Microsoft-clould-drive will disable autosave. Are you sure?" Oh, and shouldn't those checkboxes be grayed out if they aren't applicable? And how about a response here?

Just lost 2 weeks of work. Unbelievable. All the right boxes ticked.

I don't know what is happening, but I have had two crashes and both times there WAS an AutoRecover file for me to recover! I did not loose any data????? I did have an update yesterday. I am not sure if that fixed it or not!

Excel 2016 AutoRecover not working - NO files being saved to the AutoRecover File location

Anonymous

Document Recovery (AutoRecover) is not working for Excel 2016.

System:

Windows 8.1 64 bit

Microsoft Excel 2016 MSO (16.0.8528.2126) 64 bit

No fix even after a full Online repair of Office 2016 and, of course, all possible Office Updates.

After working for hours on several Excel documents (which had previously been saved with a file name etc.), the power went out in our building. When the power was restored and Excel reopened, I was presented with the expected list of Recovered Documents on the left side. HOWEVER, every single one of these were simply "the Original version" or "the version last saved by user" (something like that).

Meaning they did not contain ANY new data that had been entered since the last time I had saved them/reopened them despite the AutoRecover being set to 1 minute.

NOTES:

Document Recovery seems to be working for Word and PP.
The settings in Options>Save are all the same for all Office products: currently set to AutoRecover every 1 minute.
The ...AppData>Roaming>Microsoft>Excel folder contains no backup file/folder for new or reopened Excel Documents. Thank goodness, the AutoRecover does seem to be updating the equivalent folder for Word ("AutoRecovery save of DocumentX.asd" files get updated) and PowerPoint (the "pptXXX.tmp" file also updated).

Edit: This is obviously some MSOffice Bug. Of the multiple 'test' spreadsheets I've been playing around with to study this, exactly 1 of them seems to actually back up. But absolutely no other ones and none of my previously created sheets ever backup to AutoRecover.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

I finally found the right location of the autorecovery files for Mac users of Excel!

See: this post on this forum

0 comments

94 additional answers

Anonymous

2018-03-18T11:27:44+00:00

'autosave' and 'autorecover' are different features right?
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-15T19:47:07+00:00

Same problem, checkboxes correct, has happened twice. It appears that Microsoft no longer supports autosave unless the file has already been saved to one of their cloud locations. "If you have Office 2016 with an Office 365 Subscription you should have the AutoSave feature which automatically saves what you're working on in real time as long as the file you're working on is saved to OneDrive or SharePoint." "This file location doesn't support AutoSave. Save to OneDrive or SharePoint Online if you want to use AutoSave." This would be more palatable if they did it more transparently, but they seem to be letting people lose their data by not warning them that the autosave feature is otherwise disabled. How about this: "Saving to a non-Microsoft-clould-drive will disable autosave. Are you sure?" Oh, and shouldn't those checkboxes be grayed out if they aren't applicable? And how about a response here?
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-15T10:19:47+00:00

Just lost 2 weeks of work. Unbelievable. All the right boxes ticked.
Was this answer helpful?

0 comments No comments
Anonymous

2018-03-14T19:08:06+00:00

I don't know what is happening, but I have had two crashes and both times there WAS an AutoRecover file for me to recover! I did not loose any data?????

I did have an update yesterday. I am not sure if that fixed it or not!
Was this answer helpful?

0 comments No comments