XL98: Show Pages Does Not Use Sheet Template for Worksheets (183611)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q183611 SYMPTOMS
If you use the Show Pages shortcut menu command to create separate
worksheets for all of 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.
To use an existing worksheet template when you use the Show Pages menu
command to create new worksheets, create and run a macro that simulates the
Show Pages functionality. For a sample macro that simulates the command,
see the "More Information" section in this article.
NOTE: There is no way to manually force the Show Pages command to create
new worksheets that use 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 Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Group and ungroup data in a
PivotTable" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
Modification Type: | Major | Last Reviewed: | 6/17/2005 |
---|
Keywords: | kbbug kbcode kbnofix kbProgramming KB183611 |
---|
|