Microsoft Office Tutorials and References
In Depth Information
File Types
File Types
Although the Excel 2010 default file format is an XLSX workbook file, the program can also open
and save a wide variety of other file formats. This section provides an overview of the file types
that Excel 2010 can handle.
Beginning with Excel 2007, Microsoft removed support for Lotus and Quattro Pro
spreadsheet file formats.
Excel file formats
Excel 2007 introduced a new default file format, and that format is also used in Excel 2010.
However, these recent versions can still read and write older Excel file formats.
To change the default file save setting, choose File➜Options and click the Save tab in
the Excel Options dialog box. You’ll find a drop-down list that lets you select the
default file format.
Table 4-2 lists the Excel file types that Excel 2010 supports. Keep in mind that an Excel workbook
or add-in file can have any extension that you like. In other words, these files don’t need to be
stored with the standard extensions shown in the table. However, Excel may display a warning if
you try to open a file in which the content does not match the extension.
Table 4-2: Excel File Types
File Type
Extension Read/Write
Notes
Excel Workbook
xlsx
Yes/Yes
The default Excel 2010 file format. It can’t store VBA
or XLM macro code.
Excel Macro-Enabled
Workbook
xlsm
Yes/Yes
The Excel 2010 file format for workbooks that contain
macros.
Excel Binary
Workbook
xlsb
Yes/Yes
The Excel 2010 binary file format. It’s an updated
version of the previous XLS format.
Template
xltx
Yes/Yes
The Excel 2010 file format for a template. It can’t
store VBA or XLM macro code.
Macro-Enabled
Template
xltm
Yes/Yes
The Excel 2010 file format for a template that
contains macros.
Excel Add-In
xlam
Yes/Yes
The Excel 2010 file format for an add-in. It can store
VBA and XLM macros.
Excel 97–Excel 2003
Workbook
xls
Yes/Yes
The Excel binary format (BIFF8) that’s compatible
with Excel 97 through Excel 2003.
Excel 97–Excel 2003
Template
xlt
Yes/Yes
The Excel binary template format (BIFF8) that’s
compatible with Excel 97 through Excel 2003.
 
Search JabSto ::




Custom Search