Button Include Hidden Items in Totals (Pivot Table) never enabled

J

juliano.net

I've created a Pivot Table that brings data from another worksheet i
the same file as Pivot Table.

So I choose to hide some lines of my worksheet, but the Pivot Tabl
toolbar button "Include hidden items in Totals" stays disabled.

Isn't this the exact function of this button
 

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

Always display items AND Include hidden items in totals 0
Pivot Table toolbar - button always disabled 0
Issue with hidden field in Pivot table 1
Value filter missing in pivot table 3
Pivot Table "Include hidden items in totals" 0
Can't open pivot table field list 1
pivot table - show items with no data 0
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top