Forum Discussion
giors600
Aug 09, 2021Copper Contributor
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...
HansVogelaar
Aug 09, 2021MVP
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.
giors600
Aug 09, 2021Copper Contributor
Right. By saying "inherently safer" you actually mean viruses which sometimes come from and are stored in malicious Excel files ? or you are referring to other safety concerns? (like Excel stability, data stability with XLSB files)
So generally if you are working with big files and there is no security concerns, you should used XLSB format? As you know computers struggle opening/working with big files so with XLSB and it's advantage of smaller file sizes, must improve performance I think.
I understand that contents doesn't change, only the format. Many thanks
So generally if you are working with big files and there is no security concerns, you should used XLSB format? As you know computers struggle opening/working with big files so with XLSB and it's advantage of smaller file sizes, must improve performance I think.
I understand that contents doesn't change, only the format. Many thanks
- HansVogelaarAug 09, 2021MVP
By safer, I meant that a .xlsx workbook by definition cannot contain VBA code, so no macro viruses.
There is no stability concern with .xlsb files.