Excel binary format (Advice - Pros and Cons) I have just started looking at it

[Jamie McMillan]

Hello,

Does anyone know about excel binary format.

I have a file with many macros in it. I read that the macros may not function properly in Excel binary format. (I read later that this is a myth???)

The file will be shared on many computers: Will it run properly???

I also read that using that format your macros can be protected - (Maybe no access to VBA editor???)

*** And if I save a file as Excel binary can I save it as a macro enabled workbook later???

Thanks for any help/suggestions: and anything I may not have thought about.

Jamie

 

[alansidman]

XLSX or XLSB: Why to save a workbook in binary format

Facts & Myths About Binary Excel Workbooks: Learn the advantages & disadvantages of Excel's binary file format XLSB

www.spreadsheet1.com

 

[MARK858]

The article in the link states
"Power Query cannot read data from binary XLSB workbooks. Excel shows an odd error after a long delay, if you try to create a Powery Query from a binary workbook"

I don't know what version they were using but a xlsb loads fine for me in 365 and I can't remember having any issue in previous versions
----------------------------------------------------------------------------------------------------------------------------
I have a file with many macros in it. I read that the macros may not function properly in Excel binary format. (I read later that this is a myth???)
It is a myth

I also read that using that format your macros can be protected - (Maybe no access to VBA editor???)
The VBE is the same on a xlsm or an xlsb file, the built in protection options are the same.... weak

*** And if I save a file as Excel binary can I save it as a macro enabled workbook later???
Yes, you can save it as any other Excel file type