I have this same problem. I tried running this macro and, if I ran it
correctly, it didn't fix the problem.

I have many spreadsheet with pivot tables and have always been able to see
the field list until today. Now I can't see it on any of my spreadsheet. So I
assume that the problem is with some global setting. Is there somewher I can
rest the global settings for pivot tables?

"LindaB" wrote:



"Daniel.C" wrote:

Try the following macro :

Sub test()
Application.CommandBars("PivotTable Field List").Enabled = True
End Sub

HTH
Daniel

When I create a pivot table, the field list does not appear. I click the
icon on the pivot table toolbar and nothing happens. I just suddenly stopped
appearing.

Any suggestions?