Xlsm vs xlsb

Closed
vcoolio
Posts
1345
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 20, 2022
- Sep 27, 2014 at 12:52 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Sep 29, 2014 at 02:46 AM
Hello everyone,

I've been reading up on the two different file formats and discovered a large variance in opinions. XLSB, being binary, apparently operates much faster than XLSM and hence is ideal for large spread sheets.

I've tried both formats and haven't noticed any difference.
Would it be a better option to save my current xlsx and xlsm files as xlsb (especially the ones with larger macros)?

I would be extremely interested in, and very appreciative of, the opinion of this forum's experts and regulars.

Kind regards everyone.
vcoolio.

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Sep 29, 2014 at 02:46 AM
0