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.

Thank you for your response. Sadly, the first 75% of your reply is generic information on how one might use/need to use the AutoRecover feature and how to set the interval etc. You may have noticed from my question, that I know how to set it and how it SHOULD work.... but it DOES NOT WORK. This leaves only one (maybe 2) questions from what you have suggested. As you have read, I have done a full Online Repair of MS Office 2016. First, are you saying that an uninstall and reinstall would possibly have a different result than the full Online Repair? Second, how do you uninstall and reinstall ONLY Excel as you suggest? Thank you.

Hello, AutoRecover helps protect files in case of a crash. If you reopen the file after a crash, a version of the file with your latest changes appears in a Document Recovery pane. We still suggest that you save manually in order for the feature to begin working. If you neglect to save again within the specified time frame, an AutoRecovery file is created & it is updated on the same basis. It's still recommended that you periodically save your work (a simple Command+S when needed is all it takes). The amount of new information that the recovered file contains depends on how frequently a Microsoft Office program saves the recovery file. For example, if the recovery file is saved only every 15 minutes, your recovered file won't contain your last 14 minutes of work before the power failure or other problem occurred. To be extra safe, enter a small number in the minutes box, like 5 or 10. That way, you’ll never lose more than 5 or 10 minutes of work. On the other hand, if you want to make Office faster, try entering a larger number in the minutes box, like 20. You may try to uninstall and reinstall the Excel application then set again the settings to refresh it. Click File > Options > Save . Make sure the Save AutoRecover information every x minutes box is selected. In Word, Excel, and PowerPoint, make sure the Keep the last autorecovered version if I close without saving box is selected. Let us know how it turns out for you. Thank you.

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

2017-10-20T00:01:04+00:00

Thank you for your response.

Sadly, the first 75% of your reply is generic information on how one might use/need to use the AutoRecover feature and how to set the interval etc. You may have noticed from my question, that I know how to set it and how it SHOULD work.... but it DOES NOT WORK.

This leaves only one (maybe 2) questions from what you have suggested. As you have read, I have done a full Online Repair of MS Office 2016. First, are you saying that an uninstall and reinstall would possibly have a different result than the full Online Repair? Second, how do you uninstall and reinstall ONLY Excel as you suggest?

Thank you.
Was this answer helpful?

30+ people found this answer helpful.

0 comments No comments
Anonymous

2017-10-19T23:52:55+00:00
Hello,

AutoRecover helps protect files in case of a crash. If you reopen the file after a crash, a version of the file with your latest changes appears in a Document Recovery pane. We still suggest that you save manually in order for the feature to begin working. If you neglect to save again within the specified time frame, an AutoRecovery file is created & it is updated on the same basis. It's still recommended that you periodically save your work (a simple Command+S when needed is all it takes).

The amount of new information that the recovered file contains depends on how frequently a Microsoft Office program saves the recovery file. For example, if the recovery file is saved only every 15 minutes, your recovered file won't contain your last 14 minutes of work before the power failure or other problem occurred. To be extra safe, enter a small number in the minutes box, like 5 or 10. That way, you’ll never lose more than 5 or 10 minutes of work. On the other hand, if you want to make Office faster, try entering a larger number in the minutes box, like 20.

You may try to uninstall and reinstall the Excel application then set again the settings to refresh it.
1. Click File > Options > Save.
2. Make sure the Save AutoRecover information every x minutes box is selected.
3. In Word, Excel, and PowerPoint, make sure the Keep the last autorecovered version if I close without saving box is selected.
Let us know how it turns out for you.

Thank you.
Was this answer helpful?

0 comments No comments