Hide "All" in pivot table

  • Thread starter Thread starter Dennis Cheung
  • Start date Start date
D

Dennis Cheung

I need to hide "All" in the pull down menu of a pivot table. Can I do that? I
don't know if it is called "All" since I am using non english version.
For example, in the "Month" field, there were months from Jan to Dec, and
you can select "All" for all months consoildation, I need to hide the
selection "A'll'.
 
Roger,
Which example are you referring to? Since there were tens of emamples in the page.
I have the same problem as Dennis....Need to hide "All' in the page filed of a pivot table.

Thanks,
Samuel
 

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

Wanted to show 12 month Date in Pivot table 2
VBA to Update Pivot Table 1
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Language independent VBA - hiding "blank" in pivot? 1
Pivot table multiple filters 2
Using VBA on Excel Pivot Tables 3
Pivot Table - Show All 0

Back
Top