Microsoft Office Tutorials and References
In Depth Information
If you need to save files in other formats, the Save As Type drop-down list in the Save As
dialog box includes a number of special formats you can select, including Excel 97-2003
Workbook and Microsoft Excel 5.0/95 Workbook.
For more information about the newer, less-restrictive limitations of Excel, see “If you missed
the last two upgrades” in Chapter 1, “What’s new in Microsoft Excel 2013.”
Understanding the “XL” formats
Although Microsoft trimmed some of the lesser-used file formats from the last release, the
volume of native Excel file formats has swelled somewhat, largely due to
accommodating legacy file formats—that is, file formats employed in previous versions of Excel. We’ll
explain the major differences here:
Excel Workbook (XLSX) This is the default Excel 2013 (and Excel 2010 and 2007)
file format, which is based on XML and uses ZIP compression for reduced file size and
increased security. Unlike the default file format in older versions of Excel (XLS), this
format does not support VBA or XLM macro code.
Excel Macro-Enabled Workbook (XLSM) Microsoft created a completely separate
XML-based file type to be used for workbook files containing VBA or XLM macro
code. This increases security by making it impossible to inject macro code into
nonmacro-enabled workbooks and makes for easier identification of files containing
Excel Binary Workbook (XLSB) This is a lean and mean file format designed for
the fastest possible loading and saving. It supports all the features of Excel 2013 and
also supports macro code, but it is not XML based, does not use compression, and is
less secure than XML-based formats.
Excel Template (XLTX) This is the template version of the Excel 2013 (and Excel
2010 and 2007) file format. This format does not support VBA or XLM macro code.
Excel Macro-Enabled Template (XLTM) This is the template version of the Excel
2013 (and Excel 2010 and 2007) file format that does allow VBA and XLM macro
Excel 97-2003 Workbook (XLS) This is a legacy file format used by previous
versions of Excel.
Microsoft Excel 5.0/95 Workbook (XLS) This is a legacy file format used by
previous versions of Excel.