XL97: Printing or Faxing Entire Workbook Sends Multiple Jobs

ID: Q166274

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

1. 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.

2. 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.

Additional query words: delrina winfax pro msfax 8.0

Keywords          : kb3rdparty kbprint
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: December 6, 1998