Pivot Table field list issue

[rcgyuk]

Hi all,

My issue is this. I open a workbook containing a pivot table. When I select the pivot, the field list appears. I close the field list and save the file. Next time I open the file the field list appears again.

This is extremely annoying. Any time I select a cell in any pivot for the first time since opening the file, I have to close the field list because it is in the way.

How can I prevent this ?

Robert.

 

[I_know_nuffin]

Have you unselected the Fields list in the Analyse menu?

 

[rcgyuk]

I can see a ribbon group called PivotTable Analyse but not Analyse.

I can't see any fields list in that group.

There is Field List in the Show group, but that does the same as clicking the X and it comes back when you re-open file

 

[I_know_nuffin]

I can see a ribbon group called PivotTable Analyse but not Analyse.

I can't see any fields list in that group.

There is Field List in the Show group, but that does the same as clicking the X and it comes back when you re-open file

this is what I meant :- when a pivot table is selected

 

[rcgyuk]

If I unselect Field list as per your screen shot, when I reopen file it has become selected again

 

[I_know_nuffin]

Did you save it or just close and reopen ?

just double checked on mine and saved - closed - opened and it remains unselected

 

[rcgyuk]

I saved with the field hidden and it opens with the field visable