Therefore, the above claim seems to be a myth. Over years, we have come across about an equal number of binary and non-binary corrupted workbooks. 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.".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |