Xlsm vs xlsb

Closed
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Sep 27, 2014 at 12:52 PM
venkat1926 Posts 1863 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 response

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