Forum Discussion
Changing format to XLSB - big excel file with many formulas, links etc.
Hi We are working with big excel files, around 30MB-200MB. We used standard XLSB file format which is default. 1. As I know XLSB offers better performance and maybe other advantages also wh...
The .xlsx format does not support macros (VBA code), hence it is inherently safer than .xlsm and .xlsb. Since most users only create small workbooks, the file size doesn't really matter for them.
Therefore .xlsx as default works well for the majority of Excel users.
If you work with very large workbooks, as you do, it makes sense to use .xlsb as default format. It won't affect the contents of the workbooks, just the way the workbooks are stored.