Selecting Dataset(s) From Data Picklist

[JPC]

I'm trying to create a Pivot Table using multiple
datasets, each set a different metric used to evaluate
individual performance. When I first add each item to the
data field they show up on the "data" grey button picklist
along with the usual "(show all)" option. If I de-select
one of the items it disappears permanently from the
picklist making it impossible to re-select it. (I can add
it again but cannot give it to my boss this way!) Is
there something "special" about the data field that
prohibits what I'm trying to do? This behavior does not
occur with any of my row or column items. The source
data, a single worksheet has columns for persons name,
location, date and then several columns, one each for each
metric measure (e.g. Trouble Tickets Closed, Num Hours to
Close, etc.) I've installed Office SP3 and reinstalled
Excel but that didn't help me. Some Excel gurus at work
say they do what I'm trying to do all the time but have no
idea why mine isn't working. . . Can anyone help?!

 

[Debra Dalgleish]

I think your colleagues are remembering incorrectly.

There's no Unhide option for the data fields. Once you uncheck a field,
it's removed from the pivot table. To see it again, you can drag the
field back in from the field list, as you're doing now.

Maybe you could create a macro for your boss, to add or remove specific
fields from the data area.