XL2000: Print Reports Do Not Print the Correct Views (214110)
The information in this article applies to:
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 INFORMATIONThe 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.
REFERENCESFor additional information about creating views, creating reports, andprinting reports, click the article number below
to view the article in the Microsoft Knowledge Base:
214258 XL2000: How to Create Multiple Views and Create and Print a Report
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbprb kbprint KB214110 |
|---|
|