XL97: Printing or Faxing Entire Workbook Sends Multiple Jobs (166274)

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 installed. -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, follow the steps below.

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 Page Setup. On the Page tab, select a resolution supported by your printer and then click OK.

For more information about creating a workbook template, click Contents And Index on the Help menu, 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 "Customize the defaults for a workbook or worksheet by using a template" topic.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.