xlsm

  • Thread starter Thread starter WhytheQ
  • Start date Start date
W

WhytheQ

Good Morning,
An easy question to start the week:
Any disadvantages to saving all Excel files as xlsm, rather than xlsx?

Regards,
Jason.
 
If you have no VBA code, then the two types are essentially the same. An
XLSX cannot store VBA code. If you do have VBA code, you need to save as
XLSM.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
So really, unless it is definitely just a data sheet, I may aswell
always use xlsm (as I might want to add code later)
Thanks for the help Chip.

JasonQ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forwards/backward compatibility Excel 2003-2007 8
Fun with GetOpenFilename 4
Excel 2007 Save as .xlsm 3
Saving in .xlsm format by default 6
xltm saveas xlsm 6
Save as, changing default fileformat in Excel 2007 4
Reasons behind having xlsx and xlsm 1
Save As and new workbook new name used in existing code 8

Back
Top