Autorecovered & xlsb workbooks

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,687
Office Version
  1. 365
Platform
  1. Windows
Ever since I "upgraded" (and I use that term sarcastically, pejoratively, and a few other terms I can't use here) to Win 11 and Office 365, I frequently run into a "autorecovery" situation that I never remember encountering before on Win 10 or Office 2017. It only happens with Excel files, usually overnight, and usually after I have had several open for more than a day. I go to work with one of the open workbooks, and I see this:

1718215931352.png


The filetype is "xlsb".

If I click on File > Info, the option to open the file location is missing. This is probably because this "AutoRecovery" file has not been saved.

If I try to save (Ctrl+s), I see this:

1718216632316.png


It looks (to me) like it is going to be saved in a Roaming folder and the filetype will be xlsx.

Questions about this condition:
  1. Why is this happening and what do I need to do to stop it?
  2. How should I handle this when it happens. I currently have 6 workbooks open, all with this condition.
  3. How do I make sure that I have the most current version with any and all changes I might have made since the last save.
Questions about xlsb files:
  1. Why are the AutoRecovery files given the filetype xlsb?
  2. I looked up xlsb. It says that it is a "binary workbook file". It also says that binary files can be loaded much faster and this is useful for large workbooks. I have a couple of large workbooks. Should I change them to xlsb? If so, how do I go about that?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,223,885
Messages
6,175,184
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top