XL5: Print Dialog Box Does Not Update Number of Copies

 Last reviewed: September 12, 1996
Article ID: Q109066
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c

SUMMARY

In Microsoft Excel, when you specify a number of copies to be printed in the Printer Setup dialog box, this number is not updated in the Print dialog box (from the File menu, choose Print). However, the number of copies you specify in the Printer Setup dialog box in Microsoft Excel IS passed to the Printers Setup dialog box in Windows Control Panel and will be applied to any new workbooks you create in Microsoft Excel. This setting will also be used by other Windows applications.

When you choose the Options button in the Page Setup dialog box (choose Page Setup from the File menu), the changes you make will affect only the current worksheet. Although this dialog box resembles the Windows Printer Setup dialog box, it will affect only the current document (while the Printer Setup dialog box will affect all documents, regardless of the application).

MORE INFORMATION

Steps to Reproduce Behavior

  1. In cell A1 of a new worksheet, type "Test".

  2. From the File menu, choose Print and choose the Printer Setup button.

  3. In the Printer Setup dialog box, choose the Setup button.

  4. Change the number of copies to 2.

  5. Choose the OK button twice.

  6. Choose the Print button (or the Preview button if you do not want to actually print a copy of your document).

  7. Select File and choose Print (to bring up the dialog box again).

In the current Workbook, the number of copies in the Print dialog box will remain 1 and will not change (even when you save the workbook, and close and reopen it); however, the Copies setting for all subsequent workbooks will be updated to 2.

REFERENCES

"User s Guide," version 5.0, Chapter 14

For more information about the Print command, choose the Search button in Help and type: 

    print command

KBCategory: kbprint
KBSubcategory:

Additional reference words: 5.00 5.00c



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.