What happened to Pivot Table "Show Pages"?

[Guest]

What happened to the functionality in Pivot Tables to write a new worksheet
for each value in a Page Field?
I'm sure that it was available in earlier versions of Excel, indeed there
are references to "show pages" in other threads in this group, but I can't
find it in Excel 2003.

Did it go away?

 

[Debra Dalgleish]

What happened to the functionality in Pivot Tables to write a new worksheet
for each value in a Page Field?
I'm sure that it was available in earlier versions of Excel, indeed there
are references to "show pages" in other threads in this group, but I can't
find it in Excel 2003.

Did it go away?

 

[Guest]

Well, I'm not completely nuts! The default installation doesn't include that
button on the Pivot Table toolbar.

Thanks for your prompt and enormously helpful reply!

 

[Debra Dalgleish]

You're welcome. I'm glad you found it!

In Excel 2000, Show Pages was also included in the shortcut menu that
appears when you right-click on the pivot table. In Excel 2002 and Excel
2003, it's not there.