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.
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.
xl2007 - Windows 7
xl hates the 255 number
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.....
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
Last edited by DocAElstein; 05-08-2024 at 02:35 AM.
Thanks Spreasheet1 - that is good to know
xl2007 - Windows 7
xl hates the 255 number
Posting Permissions
Reply With Quote
Bookmarks