The information in this article applies to:
- Microsoft Excel 97 for Windows
SYMPTOMS
When you print or fax a document from Microsoft Excel 97, the document may
be printed or faxed twice. The first job contains the first sheet and the
second job contains the remaining sheets.
CAUSE
This problem occurs if all of the following conditions are true:
- You create the workbook in Microsoft Excel 97 while a fax driver is
active.
-and-
- You click Entire Workbook in the Print dialog box or you select all the
sheets in the workbook, and then click Active Sheet(s) in the Print
dialog box.
WORKAROUND
To work around this problem, use one of the following appropriate methods.
Note that you must use the workaround for each existing or new workbook.
Existing Microsoft Excel 97 Workbooks
- Open an existing workbook by clicking Open on the File menu. In the Open
dialog box, select the workbook that you want to print or fax and click
Open.
- Click Print on the File menu. In the Print dialog box, select a printer
driver other than the fax driver. Then, click Cancel.
- Select all sheets in the workbook. To do this, click the first
worksheet, hold down SHIFT, and then click the last sheet in the
workbook.
- On the Edit menu, click "Move or Copy Sheets." In the Move Or Copy
dialog box, click the (new book) option in the To list. Click the Create
A Copy check box to select it and click OK.
- In the new copy of the workbook, select all of the sheets. To do this,
repeat step 3.
- On the File menu, click Print Preview. In print preview, click Close.
- On the File menu, click Print. In the Print dialog box, select the Fax
driver and click Print to fax the workbook.
New Microsoft Excel 97 Workbooks
- On the File menu, click Print. In the Print dialog box, select a printer
driver other than the fax driver. Then, click Cancel.
- Select all sheets in the workbook. To do this, click the first
worksheet, hold down SHIFT, and then click the last sheet in the
workbook.
- On the File menu, click Print Preview. In print preview, click Close.
- Click Save on the File menu, enter in a name for the workbook, and then
click Save to save the file.
After you use the methods in this article, the workbook is printed or faxed
correctly and it is not necessary to repeat the steps for that workbook.
However, you must repeat the steps for new workbooks to fax the workbook
correctly. If you frequently fax from Microsoft Excel 97, it may be helpful
to create a workbook template.
For more information about creating a workbook template, click the Index
tab in Microsoft Excel Help, type the following text
templates, customizing workbook defaults
and then double-click the selected text to go to the "customizing workbook
default" topic.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
|