If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Button Include Hidden Items in Totals (Pivot Table) never enabled
I've created a Pivot Table that brings data from another worksheet in the same file as Pivot Table. So I choose to hide some lines of my worksheet, but the Pivot Table toolbar button "Include hidden items in Totals" stays disabled. Isn't this the exact function of this button? -- juliano.net ------------------------------------------------------------------------ juliano.net's Profile: http://www.excelforum.com/member.php...o&userid=33189 View this thread: http://www.excelforum.com/showthread...hreadid=530061 |
#2
|
|||
|
|||
Button Include Hidden Items in Totals (Pivot Table) never enabled
Please see Deborah's comment on this topic.
http://groups.google.com/group/micro...b091f3e9f9 dc "juliano.net" wrote: I've created a Pivot Table that brings data from another worksheet in the same file as Pivot Table. So I choose to hide some lines of my worksheet, but the Pivot Table toolbar button "Include hidden items in Totals" stays disabled. Isn't this the exact function of this button? -- juliano.net ------------------------------------------------------------------------ juliano.net's Profile: http://www.excelforum.com/member.php...o&userid=33189 View this thread: http://www.excelforum.com/showthread...hreadid=530061 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
updating pivot table to include additional rows | Ellen | General Discussion | 8 | July 15th, 2008 01:33 PM |
Incorrect totals in Pivot Table | Jake | General Discussion | 1 | January 11th, 2006 10:58 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Pivot Table Zero Value | jcliquidtension | General Discussion | 0 | January 13th, 2005 04:21 AM |
Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |