pivot table field list keeps disappearing / fields dont appear in order

[bigdan]

Whenever I click outside of the pivot table the field list keeps disappearing. Is there a way to fix it there? You'd think this would be a simple google but I'm not finding it.

Can anyone advise?

 

[Aryatect]

Hi, Think of it this way 1 worksheet can have multiple pivot tables which may or may not refer to the same source raw data, if field list would appear if you click anywhere and add any field how would the system know which table you are adding fields to. That is why I think it doesn't appear when you click anywhere else outsite Pivot table.

 

[bigdan]

ahhh! gotcha. thanks.

 

[Aryatect]

Glad could help!