![excel autosave not working excel autosave not working](https://www.exceltip.com/wp-content/uploads/2013/07/img123.png)
If I ever get more information I'll post it here. It may mean nothing, in that the "unexpected error" piece suggests it's just a catch-all error message. I've never figured out how much of a clue the "autorecover has been disabled" gives us. I think it must be related to memory somehow, where some combination of events over time causes the problem.
![excel autosave not working excel autosave not working](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/02/autosave-in-excel.png)
Given which, Microsoft must know about it but they, too, haven't figured it out. So that's consistent with it not being a problem caused by the workbook per se.Īs I say, I've known about the problem for 10 years or so, and several people that I've worked with over the years know about it. Magemaester's original post is interesting, in that they found that a colleague could open the file fine. So there isn't a workbook that I could give you to help troubleshoot. The problem is that it happens randomly and can happen with seemingly any workbook. Thanks for responding, and thanks for the very generous offer of your time. Does anyone have an idea what's causing this? Its quite annoying and I feel like this a computer-specific issue (since my colleagues have no issue using any of the workbooks that I couldn't), rather than any of my workbooks being corrupted. but everyone seems to have a different problem to mine. I've tried googling and looking up this error. But now, even opening relatively small files, I could sometimes get this error out of nowhere (although this time around it didn't affect my ability to save the file). But recently I discovered that, ever since that incident, the "Autorecover has been disabled." message would occasionally come back to haunt other excel files that I open (which were completely fine before this whole incident). So my immediate conclusion was that this error only pertained to this huge model that I was building, and so I wasn't too fussed about it because it was only 1 file. a few days) before the 'An Unexpected Error has Occurred.' error showed up again - which meant I had to ask my colleagues to create another duplicate workbook using 'Save As'.
![excel autosave not working excel autosave not working](https://aws1.discourse-cdn.com/uipath/original/3X/3/9/39d0bf58eb055e663391c2bcc3cebcd3b75e67e9.png)
This meant that whenever the workbook became un-saveable on my own laptop, I just had to ask a colleague to save the file in a different name, which would make that workbook capable of being saved on my own laptop. But to my surprise, not only could my colleagues open that notebook and save it without a hitch, but also I could workaround this error if I got my colleagues to 'Save As' the workbook in a different name, and work on that one instead. I thought the workbook must have been corrupted. It didn't matter if I closed the workbook and reopened it again, I was no longer able to save it. As soon as that error occurred, I could no longer save the workbook. However one time it crashed, and when I reopened Excel after that instance, the error message "An unexpected Error has occurred - autorecover has been disabled for this session of Excel' occurred. The model due to its size was a little cumbersome and slow to work with, but it worked well for its purpose. I built quite a large Excel model (280mb) as part of a company project.