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...
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
HansVogelaar
Aug 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.