Article ID: 112101
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 95a
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q112101
SYMPTOMS
In Microsoft Excel, when you print a report (from the File menu, choose Print Report), the pages in your report are not numbered consecutively.
CAUSE
The pages of your report may not be numbered consecutively if the First Page Number setting in the Page Setup dialog box was set to Auto, instead of 1, when the first view in the report was added.
The Print Report command uses the first view in the report to determine the initial page number: when this number is Auto, the Print Report add-in does not acknowledge the Use Continuous Page Numbers setting in the Add Report and Edit Report dialog boxes; instead, each view begins with page 1.
Example
If you have a workbook that contains four worksheets, each with the following defined views
Worksheet Defined Views
-------------------------
Sheet1 View1, ViewA
Sheet2 View2, ViewB
Sheet3 View3, ViewC
Sheet4 View4, ViewD
and you want to print a report that includes the following views (in the order shown)
Sheet3, View3
Sheet2, ViewB
Sheet1, View1
Sheet4, ViewD
and you want to use continuous page numbers, the Use Continuous Page Numbers setting will not work correctly unless the First Page Number setting was set to 1 at the time View3 (the first view in the report) was added.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
WORKAROUNDS
To print reports with continuous page numbers, the first view in the report must have its First Page Number setting set to 1. To change this setting for your reports, do either of the following:
- Change the First Page Number setting for all sheets to 1 BEFORE you add any views -or-
- Change the First Page Number setting for the first view in the report, and redefine the view
NOTE: To use either of these workarounds, the Use Continuous Page Numbers check box (in the Edit Report or Add Report dialog box) must be selected.
To change the First Page Number
Setting for all sheets before adding views
- From the sheet tab shortcut menu, choose Select All Sheets.
- With all the sheets selected, choose Page Setup from the File menu, and select the Page tab.
- In the First Page Number box, type "1", and choose OK.
To change the First Page Number setting for the
First view in the report, and then redefine that view
- Activate the sheet that contains the first view in the report.
- From the View menu, choose View Manager.
- From the list of Views, choose the first view in the report and choose the Show button.
- From the File menu, choose Page Setup, and select the Page tab.
- In the First Page Number box, type "1" and choose OK to accept the change.
- From the View menu, choose View Manager. In the View Manager dialog box, choose the Add button.
- In the Name box, type
View3
where View3 is the name of the first view in your report.
- Under Include With View, make sure that the Print Settings check box is selected. Choose OK.
- When you are prompted to "Overwrite existing view <viewname>?", choose OK.
When you print the report, the report should be printed using continuous page numbers.
NOTE: If a different view is printed first, you will need to redefine that view so that the First Page Number setting is 1, not Auto.
MORE INFORMATION
"User's Guide," version 5.0, pages 251, 614-616
Additional query words: 5.00c XL
Keywords: KB112101
