Other file formats

Table 4-5 lists the other file types supported by Excel 2007.

Table 4-5: OTHER FILE TYPES

^ Open table as spreadsheet

Table 4-5: OTHER FILE TYPES

^ Open table as spreadsheet

File Type

Extension

Read/Write

Notes

Hypertext Markup Language (HTML)

htm, html

Yes/Yes

Excel 2007 no longer supports "round-tripping" for HTML files.

Single File Web Page

mht, mhtml

Yes/Yes

Also known as Archived Web Page. The only browser that can display these files is Microsoft Internet Explorer.

Portable Document Format (PDF)

pdf

No/Yes

The file format originated by Adobe. Requires a free add-in from Microsoft.

XML Paper Specification

xps

No/Yes

Microsoft's alternative to Adobe's PDF. Requires a free add-in from Microsoft.

Workspace Files

A workspace file is a special file that contains information about an Excel workspace. For example, if you have a project that uses two workbooks and you like to have the workbook windows arranged in a particular way, you can save an XLW file to save this window configuration. Then, whenever you open the XLW file, Excel restores the desired workspace.

To save a workspace, choose View Window Save Workspace, and provide a name when prompted.

To open a workspace file, use Office

Open and select Workspaces (*.xlw) from the Files of Type drop-down list.

It's important to understand that a workspace file does not include the workbooks - only the configuration information that makes those workbooks visible in your Excel workspace. So if you need to distribute a workspace to someone else, make sure that you include the workbook files as well as the XLW file.

4 PREV

NEXT

0 0

Post a comment