Access.2007.VBA.Bibl..

(John Hannent) #1
FIGURE 3.11

Viewing the file format choices for saving an Excel workbook.


If you create a worksheet in the new .xlsx format, only Office 2007 users will be able
to open it. To create a worksheet that can be opened and edited by users with earlier
versions of Office, select one of the other formats. The Excel 97–Excel 2003 Workbook (.xls) format
(shown being selected in Figure 3.12) is usable in Office 97 through 2007, so it is generally the most
useful worksheet format.

FIGURE 3.12

Selecting a worksheet save format.


WARNING WARNING


Analyzing Data with Excel 3

Free download pdf