I ran this macro and (if I did it right) it didn't fix the problem.

I have many spreadsheets with pivot tables and have always been able to view
the field list on all sheets. Today I can view the field list on any
spreadsheet. So I assume this is some global configuration that has gotten
set. Is there some 'reset' to factory setting 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?