What happened to Pivot Table "Show Pages"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...
 
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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Show Pages missing from Excel XP 1
Show Pages for Excel 2007 Pivot Tables 5
Pivot Table Page Break Refresh Problem 0
Pivot Table - Show Page Fields 1
Different ways to build Pivot table 1
Pivot Table criteria 2
Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table - Changes 5

Back
Top