Xlsm vs xlsb

[Closed]
Report
Posts
1318
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 20, 2021
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802