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.
Printable View
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.
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.....
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.
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/@alanelston2330
https://www.youtube.com/watch?v=yXaYszT11CA&lc=UgxEjo0Di9-9cnl8UnZ4AaABAg.9XYLEH1OwDIA35HNIei0z-
https://eileenslounge.com/viewtopic.php?p=316154#p316154
https://www.youtube.com/watch?v=TW3l7PkSPD4&lc=UgwAL_Jrv7yg7WWC8x14AaABAg
https://teylyn.com/2017/03/21/dollarsigns/#comment-191
https://eileenslounge.com/viewtopic.php?p=317050#p317050
https://eileenslounge.com/viewtopic.php?f=27&t=40953&p=316854#p316854
https://www.eileenslounge.com/viewtopic.php?v=27&t=40953&p=316875#p316875
https://eileenslounge.com/viewtopic.php?p=316057#p316057
https://eileenslounge.com/viewtopic.php?p=316705#p316705
https://eileenslounge.com/viewtopic.php?p=316704#p316704
https://eileenslounge.com/viewtopic.php?p=176255#p176255
https://eileenslounge.com/viewtopic.php?f=27&t=40919&p=316597#p316597
https://eileenslounge.com/viewtopic.php?p=316412#p316412
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Thanks Spreasheet1 - that is good to know