Forum Discussion
Welcome to the Excel Community
The excel autosave function is not working properly. I had an excel book that I had been preparing for days. I had the autosave mode ON, so I did not worry about manually saving right, thinking of course that it would autosave. So I was working on it today and my computer shut down because of a battery shortage. So I plug it in, turn it on again and my excel book was not the same. It keeps loading a version from 3 days ago, but all the modifications I made after that point were gone. I've tried checking the version history, but according to it, there were no versions from those days. I've also checked the OneDrive Recycle Bin, nothing either. I've come here after consulting with the technical support them to seek some help. Is my work lost forever? Please help
I believe there are a few things you could check to see if the workbook is recoverable.
If you are using excel application:
Firstly, you could open Excel, go to File > Open, and click Recover Unsaved Workbooks which should be near the bottom of the screen.
If this does not work then you could try searching the below path on your computer:
C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles
You would be looking for any temporary files in this location.
I think once you closed Excel or shutdown the computer normally then these temporary files would be forgotten.
If you are using Excel through your browser then go to File > Version History