What happened to Pivot Table "Show Pages"?
 

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?

--
Jim

On the Pivot Table toolbar, choose PivotTable Show Pages

Jim Molter wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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!
--
Jim


"Debra Dalgleish" wrote:

On the Pivot Table toolbar, choose PivotTable Show Pages

Jim Molter wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.

Jim Molter wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html