Microsoft KB Archive/214110

= XL2000: Print Reports Do Not Print the Correct Views =

Article ID: 214110

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214110





SYMPTOMS
In Microsoft Excel, when you use the add-in macro 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 you create the custom view.



MORE INFORMATION
The add-in that is discussed in this article is provided as-is. 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.

Microsoft Excel includes an add-in macro, Report Manager, that allows you to create a report from selected views of your worksheet. Report Manager uses views that you create when you click Custom Views on the View menu.

To ensure that your report is printed 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.

