Autorecovered & xlsb workbooks

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,691
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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,224,814
Messages
6,181,120
Members
453,021
Latest member
Justyna P

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