Hide "All" in pivot table

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'.
 

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 0
Selecting Date Range in a Pivot using VBA 0
Pivot Table Management 4
Show / Hide items in Pivot Table as required 0
Wanted to show 12 month Date in Pivot table 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Link Drop Down list with Pivot Table 3
VB Macro for Pivot Filter Function 0

Top