Microsoft Office Tutorials and References
In Depth Information
Which File Formats Does Office 2010 Support?
Table 4-2 Supported File Formats in Excel 2010
Type
Extension Description
Excel Workbook
.xlsx
This XML-based format is the default format
for Excel 2010 and Excel 2007. This
workbook type cannot contain VBA macro code
or Microsoft Excel 4.0 macro sheets. For more
information, see “Understanding the Office
2010 Default Formats: Office Open XML” on
page 85.
Excel Macro-Enabled
Workbook
.xlsm
This format is similar to the one above, except
that it can contain VBA macro code.
Excel Binary Workbook
.xlsb
This format provides extremely fast
performance for opening and saving data files. File
sizes are larger than comparable .xlsx files, and
this format is less secure.
Excel 97-2003 Workbook
.xls
This is the native format used by Excel 97,
Excel 2000, Excel 2002, and Excel 2003.
Microsoft Excel 5.0/95
Workbook
.xls
This format was widely used in the mid-1990s.
Microsoft Excel 4.0 Workbook .xlw
This import-only format dates to the early
1990s.
Excel Template
.xltx
This is the default format for templates used
in Excel 2010 and Excel 2007. This workbook
type cannot contain VBA macros or Microsoft
Excel 4.0 macro sheets. For more information,
see “Using Templates to Streamline Document
Creation” on page 97.
Excel Macro-Enabled
Template
.xltm
This format is similar to the one above, except
that it can contain VBA macro code. When
you save a workbook created from a
macroenabled template that includes macro code,
Excel prompts you to save the workbook as
macro-enabled.
Excel 97-2003 Template
.xlt
This is the template format used by earlier
versions of Excel.
Excel Add-In
.xlam
This format is used for supplemental programs
that run code. It supports the use of VBA
projects and Excel 4.0 macro sheets.
Excel 97-2003 Add-In
.xla
This is the add-in format used by earlier
versions of Excel.
Microsoft Excel 4.0 Macro
.xlm, .xla This import-only format lets you open old
macro sheets and convert them to VBA.
Search JabSto ::




Custom Search