ufce.blogg.se - Workbook has lost its vba project excel 2007

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.".