xlsm vs xlsb
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » .xlsm vs .xlsb

.xlsm vs .xlsb

resolvedResolved · Low Priority · Version 2010

Edited on Fri 6 May 2011, 15:02

mark has attended:
Excel VBA Intro Intermediate course

.xlsm vs .xlsb

Hello,

I recently discovered the possibility to save Excel files as .xlsb format, and saving my .xlsx and .xlsm files as .xlsb seems to have reduced both the files' load-up speed and file size.

I use both non-macro and macro enabled files extensively and was wondering if there were any possible drawbacks to converting all the .xlsx and .xlsm files to .xlsb, other than having to edit vba code when these files are referenced.

I have just upgraded to Office 2010, having used Office 2007 before this.

Thanks

RE: .xlsm vs .xlsb

Hi Mark, thanks for your query. I know of no reason why you shouldn't convert the lot to .xlsb files, particularly if you are throwing around a lot of code and data. You might get some slight speed and filesize improvements because there isn't any bundled xml for Excel to parse on file open. The .xlsm format is Microsoft's response to the security issues thrown up by use of the macro recorder, but if you find the separation into .xlsx and .xlsm formats tedious go ahead and resave as .xlsb. I probably would if I was doing a lot of development work.

Hope this helps,

Anthony

RE: .xlsm vs .xlsb

Thanks Anthony.

Sun 15 May 2011: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
excel consulting and other training courses.

Excel tip:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.11 secs.