MS Excel 365 - An unexpected error has occurred. AutoRecover has been disabled for this session...

%3CLINGO-SUB%20id%3D%22lingo-sub-3118621%22%20slang%3D%22en-US%22%3EMS%20Excel%20365%20-%20An%20unexpected%20error%20has%20occurred.%20AutoRecover%20has%20been%20disabled%20for%20this%20session...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3118621%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20Hoping%20to%20get%20some%20advise%20on%20the%20correct%20solution%20and%20maybe%20this%20can%20help%20someone%20else%20as%20I%20spent%20a%20bunch%20of%20time%20troubleshooting%20on%20my%20own%20and%20working%20with%20my%20IT%20folks%2C%20which%20was%20useless.%20I%20have%20Excel%20(%3C!--%20%20%20StartFragment%20%20%20%20--%3E%3CSPAN%20class%3D%22%22%3EMicrosoft%C2%AE%20Excel%C2%AE%20for%20Microsoft%20365%20MSO%20(Version%202111%20Build%2016.0.14701.20278)%2064-bit%3B%20this%20may%20be%20outdated%20slightly%20but%20my%20company%20manages%20the%20updates%3C%2FSPAN%3E%3CSPAN%3E)%20setup%20to%20open%20to%20a%20blank%20workbook%20(under%20Options%20-%26gt%3B%20Start%20up%20options%2C%20unselected%20%22Show%20the%20Start%20screen%20when%20this%20application%20starts%22)%2C%20this%20results%20in%20Excel%20opening%20Book1%3B%20this%20is%20my%20preference.%20Since%20the%20last%20update%20from%20Microsoft%20(maybe%20unrelated%2C%20but%20who%20knows)%2C%20after%20the%20specified%20time%20for%20AutoRecover%2C%20a%20popup%20warning%20appears%20and%20states%20%22An%20unexpected%20error%20has%20occurred.%20AutoRecover%20has%20been%20disabled%20for%20this%20session%20of%20Excel.%22%20The%20error%20is%20definitely%20tied%20to%20this%20Book1%20upon%20first%20opening%20Excel%20and%20happens%20every%20time%20I%20reopen%20Excel.%20I%20change%20the%20AutoRecover%20time%2C%20the%20error%20pops%20up%20shortly%20after%20that%20time%20(changed%20from%2010%20minutes%20to%202%20minutes%20and%20the%20error%20shows%20up%20after%202%20minutes%20now%20instead%20of%2010%20minutes).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMy%20initial%20troubleshooting%20to%20identify%20the%20issue%3A%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3EIf%20I%20open%20another%20workbook%20and%20leave%20Book1%20open%2C%20the%20error%20occurs%20(also%20this%20seems%20to%20be%20new%20since%20the%20update...before%20when%20I%20would%20open%20an%20existing%20workbook%2C%20Book1%20would%20automatically%20close)%3C%2FLI%3E%3CLI%3EIf%20I%20open%20another%20workbook%20and%20close%20Book1%20before%20the%20error%20occurs%2C%20it%20doesn't%20happen%3C%2FLI%3E%3CLI%3EIf%20I%20select%20the%26nbsp%3B%22Show%20the%20Start%20screen%20when%20this%20application%20starts%22%2C%20the%20error%20doesn't%20occur%3C%2FLI%3E%3CLI%3EIf%20I%20select%20new%20workbook%20from%20the%20start%20screen%2C%20it%20is%20still%20called%20Book1%2C%20but%20no%20error!%3C%2FLI%3E%3C%2FUL%3E%3CP%3EAdvanced%20troubleshooting%20I've%20already%20done%3A%3C%2FP%3E%3CUL%3E%3CLI%3ESearched%20my%20C%20drive%20and%20OneDrive%20for%20all%20files%20Book1*.*%20and%20deleted%20those%3C%2FLI%3E%3CLI%3ESearched%26nbsp%3Bmy%20C%20drive%20and%20OneDrive%20for%20all%20files%2Ffolders%20XLSTART%20and%20deleted%20those%3C%2FLI%3E%3CLI%3EDeleted%20all%20AutoRecover%20files%20in%20that%20folder%3C%2FLI%3E%3CLI%3EChanged%20the%20location%20of%20the%20AutoRecover%3C%2FLI%3E%3CLI%3EDone%20two%20repairs%3C%2FLI%3E%3CLI%3EUninstalled%20and%20reinstalled%20Office%20twice%20-%20quite%20the%20pain%20because%20reinstalled%20messed%20up%20Teams%20and%20I%20had%20to%20reinstall%20that%20as%20well%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3ESolution%20(workaround)%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3ESave%20Book1.xltx%20(Excel%20Template)%20to%3A%20C%3A%5CProgram%20Files%5CMicrosoft%20Office%5Croot%5COffice16%5CXLSTART%5C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EWhen%20I%20tried%20to%20save%20this%20file%20to%20My%20Documents%2C%20I%20got%20an%20error%20that%20stated%20%22Document%20not%20saved%22%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EThis%20solution%20did%20not%20resolved%20the%20issue%20of%20Book1%20staying%20open%20after%20I%20open%20the%20file%20I%20actually%20want%20to%20be%20working%20in%2C%20so%20this%20is%20a%20workaround%20that%20I%20can%20live%20with%20for%20now%2C%20but%20would%20love%20any%20advise%20on%20how%20to%20get%20it%20working%20correctly.%20Thank%20you%20in%20advance!%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3118621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hello! Hoping to get some advise on the correct solution and maybe this can help someone else as I spent a bunch of time troubleshooting on my own and working with my IT folks, which was useless. I have Excel (Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20278) 64-bit; this may be outdated slightly but my company manages the updates) setup to open to a blank workbook (under Options -> Start up options, unselected "Show the Start screen when this application starts"), this results in Excel opening Book1; this is my preference. Since the last update from Microsoft (maybe unrelated, but who knows), after the specified time for AutoRecover, a popup warning appears and states "An unexpected error has occurred. AutoRecover has been disabled for this session of Excel." The error is definitely tied to this Book1 upon first opening Excel and happens every time I reopen Excel. I change the AutoRecover time, the error pops up shortly after that time (changed from 10 minutes to 2 minutes and the error shows up after 2 minutes now instead of 10 minutes).

My initial troubleshooting to identify the issue:

  • If I open another workbook and leave Book1 open, the error occurs (also this seems to be new since the update...before when I would open an existing workbook, Book1 would automatically close)
  • If I open another workbook and close Book1 before the error occurs, it doesn't happen
  • If I select the "Show the Start screen when this application starts", the error doesn't occur
  • If I select new workbook from the start screen, it is still called Book1, but no error!

Advanced troubleshooting I've already done:

  • Searched my C drive and OneDrive for all files Book1*.* and deleted those
  • Searched my C drive and OneDrive for all files/folders XLSTART and deleted those
  • Searched my C drive and OneDrive for all files *.xltx and deleted those
  • Searched my C drive and OneDrive for all files *.xlb and deleted those
  • Deleted all AutoRecover files in that folder
  • Changed the location of the AutoRecover
  • Done two repairs
  • Uninstalled and reinstalled Office twice - quite the pain because reinstalled messed up Teams and I had to reinstall that as well
  • Tried to save Excel template to C:\Program Files\Microsoft Office\root\Office16\XLSTART\ and C:\Users\####\AppData\Roaming\Microsoft\Excel\XLSTART\

Solution (workaround):

  • Save Book1.xlsx to: C:\Users\####\AppData\Roaming\Microsoft\Excel\XLSTART\

This solution did not resolved the issue of Book1 staying open after I open the file I actually want to be working in, so this is a workaround that I can live with for now, but would love any advise on how to get it working correctly. Thank you in advance!

0 Replies