Unexpected Error - AutoRecover Disabled

I am receiving the following error quite frequently: "An unexpected error has occurred. Autorecover has been disabled for this session of Excel." Excel then locks up and eventually has to be shut down through Task Manager. I lose all my work at this point. This happens in the majority of workbooks I've created. It doesn't matter if they are newly created files or I'm working on one previously saved. I have read through all the other threads related to this error; I am not using pivot tables, macros or working on a network. I do not have a solid state drive. I am not copying from one workbook to another. I am using the default AutoRecover file location. I have AutoRecover enabled and set to save every 5 minutes. Sometimes this error occurs when I try to save or print. Sometimes it occurs when I'm not doing anything in the file at all. In that case, I presume it's happening when AutoRecover attempts to save. I have uninstalled and re-installed a new copy of Office.

Most recently, I opened Excel and began typing in a new workbook. I did not copy/paste anything, use macros/pivot tables, etc. I simply opened a new workbook, started typing, and it crashed. I am beyond frustrated with this. Any help would be greatly appreciated.
Answer
Answer
Hi Sali,
 
Thanks for the question! We can help you with this issue, but I’m going to need a little more information first.
Open Excel, click on File > Options > In the field next to ‘Auto Recover file location’, make sure it points to a path with sufficient permissions.
  • The default is: C:\Users\<username>\AppData\Roaming\Microsoft\Excel
  • Click OK.
You may try changing the default printer to Microsoft XPS Document Writer and then check if the issue persists.
Refer the link below to know on how to change the default printer:
 
If you have any further queries, reply and we will be glad to help you.

Thanks

60 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 6, 2024 Views 46,274 Applies to: