Microsoft KB Archive/97916

{|
 * width="100%"|

XL: Reports Aren't Printed at Reduced Size

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

-

SYMPTOMS
When you print reports in Microsoft Excel, print scaling will revert to a setting of 100-percent (full size) if you are using both the Fit To Pages option in Page Setup and the Continuous Page Numbers option in the Edit Report/Add Report dialog box.

WORKAROUND
To work around this problem, do either of the following:

 Disable the Continuous Page Numbers option:

 From the File menu, choose Print Report and choose the Edit button. In the dialog box, clear the Continuous Page Numbers check box.

If this option is turned off, print scaling will remain at the correct settings. However, your page numbers may not be sequential.

-or- Use the Reduce/Enlarge Page Setup option instead of the Fit To Pages Page Setup option.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. We are researching this problem, and will post more information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 4.00a scale view

Keywords : kbprint

Version : WINDOWS: 4.0, 4.0a; MACINTOSH: 4.00

Platform : MACINTOSH WINDOWS

Issue type : kbbug

Technology :