T
Ted M H
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 are:
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.
the icons on the pivot table toolbar do. They are:
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.