Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always display items AND Include hidden items in totals
I am working with Excel 2002 pivot tables and I need to explain what two of
the icons on the pivot table toolbar do. They a Always display items Include hidden items in totals I know my way around in pivot tables--I've been using them for years. I must be missing something obvious, but I am really stumped. I can guess what these toolbar items are supposed to do--their names sort of tell the story. But I've tried every scenario I can think of to get them to do ANYTHING, but to no avail. Always display items seems to try to refresh the table, but it never displays items that weren't already there. I've tried hiding details and then tried to use Always display items to show them again. Nothing! It seems to make absolutely no difference whether this icon is selected or not. The Include hidden items in totals icon seems never to become available--it's always greyed-out on the tool bar regardless of where my cursor is in the Pivot table. By the way, the Show Detail and Hide Detail toolbar commands work just fine, as do all the other commands. Anyone able/willing to shed some light on these two mystery items? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button Include Hidden Items in Totals (Pivot Table) never enabled | Excel Discussion (Misc queries) | |||
Pivot Table "Include hidden items in totals" | Excel Discussion (Misc queries) | |||
Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
Pivot Table unable to Include Hidden Items In Subtotals | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Charts and Charting in Excel |