I would like to know if there is a reason to not use .xlsb file format all the time, instead of .xlsx or .xlsm?
I've looked at this post: When should the xlsm or xlsb formats be used?
and also done some basic tests myself, it seems binary format is way superior. So I'm curious to know whether I shouldn't just use .xlsb all the time and say goodbye to .xlsx or .xlsm. Is there a catch somewhere?
The only reason not to use .xlsb is for compatibility reasons since since many other software applications cannot handle the format.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With