Myth: 'Binary workbooks are more prone to file corruption'.You can protect macros in binary workbooks with Unviewable+ VBA. You can save any workbook (with or without macros) in binary format. Myth: 'My workbook doesn't have macros, so I cannot SaveAs in binary format'.Saving a binary file as XLSX or XLSM will result in a larger file size - ceteris paribus - (with all Excel features stored in the file being the same) Myth: ' You can then go from xlsb back to xlsx and the smaller size prevails.Binary files use a better compression than the standard ZIP compression used in other Open XML file formats. No data is lost, when saving a workbook as a binary file format. Myth: 'I am not sure what is lost, but I know binary workbooks are more compact.'.
