Procs and Cons of XLSX and XLSM

Chartist

Board Regular
Joined
Apr 2, 2007
Messages
66
Since upgrading to 2007, I have been saving all my files as XLSM because Im not sure of any differences between the two except that XLSM will support Macros. Are there any other pros and cons to the two formats?

Many thanks
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
From this MSDN document... http://msdn2.microsoft.com/en-au/library/aa338205.aspx#office2007aboutnewfileformat_introduction

Macro-Enabled Files vs. Macro-Free Files
Default 2007 Microsoft Office system documents saved in Office XML Formats are intended to be macro-free files, and therefore cannot contain code. This behavior ensures that malicious code, residing in a default document, can never be executed unexpectedly. While 2007 Microsoft Office system documents can still contain and use macros, the user or developer must save these documents as a macro-enabled document type. This safeguard will not affect your ability to build solutions, but allows organizations to use documents with more confidence.

Macro-enabled files have the exact same file format as macro-free files, but contain additional parts that macro-free files do not. The additional parts depend on the type of automation found in the document. A macro-enabled file that uses VBA contains a binary part that stores the VBA project. Any Excel workbook that uses Excel 4.0–style macros (XLM macros) or any PowerPoint presentation that contains command buttons are also saved as macro-enabled files. If a code-specific part is found in a macro-free file, whether placed there accidentally or maliciously, the Office applications will not allow the code to execute—without exception.

You can now determine if any code exists within a 2007 Microsoft Office system document before opening it. Previously this "advance notice" was not something that could be easily accomplished outside Office. You can inspect the package file for the existence of any code-based parts and relationships without running Office and without running potentially risky code. If a file looks suspicious, you can remove any parts capable of executing code from the file, so that the code can cause no harm.
I gather from the above that there are no additional features in XLSM vs XLSX, apart from the ability of Excel 2007 tp open XLSM files that contain code.

Denis
 

Chartist

Board Regular
Joined
Apr 2, 2007
Messages
66
Thanks for that reply...
Ok, I will continue to save al new Excel files as Macro enabled
 

Watch MrExcel Video

Forum statistics

Threads
1,096,460
Messages
5,450,596
Members
405,620
Latest member
Poyda

This Week's Hot Topics

Top