XLSM vs. XLSB

[MacroEcon1337]

I have a complex workbook with a lot of macros. Yesterday, I noticed the file size shrank by 15% when I switched from .XLSM to .XLSB.

All the macros seem to work - though command buttons seem to flash strangely at times. The performance speed is about the same (less volatility in macro speed results with .XLSB).

I'm wondering is there any reason not to use .XLSB instead of .XLSM? It strikes me odd that I cannot see the advantage of using .XLSM at all. So wondering if i am missing something?

ty much,

MC

 

[joeu2004]

Google "xlsm v xlsb" without quotes. One hit:
https://analystcave.com/excel-working-with-large-excel-files-the-xlsb-format

 

[MacroEcon1337]

I did a slightly different google query, and was not satisfied with the results. But your link is everything i wanted.... thank you!

MC