Xlsm vs xlsb

Closed
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 27 Sep 2014 à 12:52
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 29 Sep 2014 à 02:46
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.
Related:

1 response

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