Microsoft KB Archive/88544

= Print Reports Not Printing Correct Views =

Article ID: 88544

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q88544





SUMMARY
In Microsoft Excel, when you use the Report Manager to print a report, the wrong range may be printed if separate print areas have not been set for each view in the report.



WORKAROUND
To prevent this problem from occurring, set the print area before creating the custom view.



MORE INFORMATION
Microsoft Excel includes an add-in macro, called Report Manager (REPORT MANAGER for the Macintosh and REPORTS.XLA for Windows), that allows you to create a report from selected views of your worksheet. Report Manager uses views that you create with the View Manager/Custom Views add-in macro. To insure that your report prints correctly, you need to set the print area when you create each view. The Print Area must be set before defining a view, or the reports may print the wrong ranges.

For additional information about creating views, creating reports and printing reports, please see the following article in the Microsoft Knowledge Base:

142529 XL: How to Create Multiple Views and Create and Print a Report

The add-in discussed in this article is provided &quot;as is&quot; and Microsoft does not guarantee that it can be used in all situations. Although Microsoft support professionals can help with the installation and existing functionality of this add-in, they will not modify the add-in to provide new functionality.

Additional query words: 5.0 97 98 XL98 XL97 XL7 XL5 XL4 XL

Keywords: kbinfo kbprint KB88544

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.