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
