XL97: Show Pages Does Not Use Sheet.xlt for Worksheets (165238)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q165238 SYMPTOMS
If you use the Show Pages shortcut menu command to create separate
worksheets for all the items for a page field in a PivotTable, the
worksheets that are created are not based on any template files that may be
on the computer.
NOTE: In Microsoft Excel 7.0, if the template Sheet.xlt is in the Xlstart
folder, the Show Pages command uses the template as the basis for new
worksheets.
RESOLUTION
To use an existing worksheet template when you use the Show Pages menu item
to create new worksheets, create and run a macro that simulates the Show
Pages functionality. See the "More Information" section in this article for
a sample macro that simulates the command.
NOTE: There is no way to manually force the Show Pages command to create
new worksheets using an existing worksheet template.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about PivotTable page fields, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Work with PivotTable
page fields" topic.
Modification Type: | Major | Last Reviewed: | 10/19/2000 |
---|
Keywords: | kbhowto kbProgramming KB165238 |
---|
|