Read/write very large xl2007 files

[Rasm]

I am wondering if I should save very large xl2007 files as XLSB rather than XLSX - simply to save time when loading/saving the xl2007 files - all my code resides in XLAM files - so no issues that way. Any comments would be appreciated.

[Excel Fox]

XLSB files do help in reducing file since, and they work just as efficiently as the normal format. Though not aware of any apparent benefits of using the normal format, I'd still recommend using XLSX for regular use, and XLSB for large files.....

[spreadsheet1]

I have used 1000s of XLSB Binary files without an issue for almost 3+ years. The larger the file (e.g. 10MB+), the larger the time & disk space saving obviously (sometimes up to 80%+). File size reduction is very useful, if files are uploaded to Sharepoint, email attached etc.

The only drawback I can think, is that the Excel file cannot be rename to ZIP and unzipped or used with some 3rd party Excel software that read only xls,xlsx & xlsm.

[Rasm]

Thanks Spreasheet1 - that is good to know