A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
I finally found the right location of the autorecovery files for Mac users of Excel!
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I finally found the right location of the autorecovery files for Mac users of Excel!
I was able to resolve this issue on my computer with windows 10 & O365. I did a Online quick repair but that didn't seem to fix it.
Then i deleted the files in "C:\Users\userName\AppData\Roaming\Microsoft\Excel"
Then my test files and all of my other files started creating files in that directory every minute like they should have. The "Keep the last AutoRecovered version if I close without saving" didn't start working until I did this as well.
good luck
How can you possibly lose 2 days of work? Do you not hit the save button in 2 days??? I dont think autosave is the issue here. Btw my last post i asked a simple question — did you turn in show hidden operating system files and what was the name of the file the system created. I work in the IT field and 99% of the posts here are just people whining without really providing any technical details. Call microsoft and open a case if you are really feeling strongly about this. I did and it turned out I was wrong and the behavior I was seeing.
Wow, it's people like you that make people hate IT people.
I too work in IT, and you are right, it is not Autosave, it is AutoRecover that is the problem. There is no hidden file created, that is exactly the problem. People "whine" because they have a problem and get no intelligent response from the arrogant techno-**** who "work in the IT field".
As this thread started last October, it seems likely to me Microsoft knew (or at least should have known!) that autorecover wasn't working. I'm pretty sure my laptop didn't crash - the autorecover files were only needed because Microsoft shut it down in order to update it. Rather inconvenient that they took away the option to opt out of automatic updates at the same time they broke autosave.
No. I did not hit Save, but as others have said, even that does not seem to guarantee anything. As for having hidden files displayed - Yes, I always have hidden files displayed. There were no hidden files in the location where Excel says that it stores the recovery files. As for not including more technical details, I doubt VERY much that that would have had any impact on getting a response from Microsoft. The original poster of this thread gave extensive details and all that they got back from Microsoft was a canned response that did not in any way address their concern. I am glad to hear that you are in the IT field. My background is electrical engineering, so I do understand technology. I've managed projects that involved hundreds of engineers spread over six sites and three countries. I've also had to address concerns from upset customers. Any thread that has gone on as long as this one has should have been addressed by Microsoft. For the most part, that has not happened. The issue is quite simple from the customer perspective. A feature that says "Save AutoRecover information every X minutes" should save AutoRecover information every X minutes. As someone with an IT background, I am sure that you can understand that having a program save a copy of a file every X minutes does not exactly constitute advanced programming. That is, unless you are dealing with spaghetti code.