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...
Side effect could be with Power Query if you use it. For example, if you have table within the file with formatted numbers
Power Query on xlsx file returns actual numbers
but Power Query on binary file returns masked by format data
and ignores structured tables.