Excel file formats

Excel 2007 uses a new default file format. However, it can still read and write older Excel file formats.

Iip To change the default file save setting, choose Office Excel 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 2007 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.

Table 4-2: EXCEL FILE TYPES

^ Open table as spreadsheet

Table 4-2: EXCEL FILE TYPES

^ Open table as spreadsheet

File Type

Extension

Read/Write

Notes

Excel Workbook

xlsx

Yes/Yes

The default Excel 2007 file format. It cannot store VBA or XLM macro code.

Excel Macro-Enabled Workbook

xlsm

Yes/Yes

The Excel 2007 file format for workbooks that contain macros.

Excel Binary Workbook

xlsb

Yes/Yes

The Excel 2007 binary file format (BIFF12). This is an updated version of the previous XLS (BIFF8) format.

Template

xltx

Yes/Yes

The Excel 2007 file format for a template. It cannot store VBA or XLM macro code.

Macro-Enabled Template

xltxm

Yes/Yes

The Excel 2007 file format for a template that contains macros.

Excel Add-In

xlam

Yes/Yes

The Excel 2007 file format for add-ins. 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.

Excel 97-Excel 2003 Add-In

xla

Yes/Yes

The Excel binary format (BIFF8) for add-ins that's compatible with Excel 97 through Excel 2003.

Microsoft Excel 5.0/95 Workbook

xls

Yes/Yes

The Excel binary format (BIFF5) that's compatible with Excel 5.0 and Excel 95.

File Type

Extension

Read/Write

Notes

XML Spreadsheet 2003

xml

Yes/Yes

Microsoft's XML Spreadsheet 2003 file format (XMLSS).

XML Data

xml

Yes/Yes

A general XML file that contains data.

Note Microsoft Office XP and Office 2003 users can install the Microsoft Office Compatibility Pack, which allows them to open and save documents in the Office 2007 file formats. The Compatibility Pack is available at http://www.office.microsoft.com.

0 0

Post a comment