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?

I am at a complete loss - I have tried this technique, and the code seemingly
ran in VBE but when I go back to my pivot tables, I still don't see the field
list. I've toggled the on/off and I've searched to see if the field list was
hiding somewhere in the open window, but after a couple weeks, I still
haven't found a resolution.

Importantly: When I run Excel in Safe Mode, the field list works perfectly!

Any suggestions??

THANKS!

"LindaB" wrote:

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?

Importantly: When I run Excel in Safe Mode, the field list works perfectly!

Try renaming Excel12.xlb or put it in another folder. With XP home, it
is located :
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel
(change USERNAME)
Daniel

Thanks, Daniel. I ended up just spending the time and reinstalling Office.
Important note for anyone who does the same down the road: make sure to
either a) delete all of the office file folders prior to reinstalling, or b)
rename them to old_* or else Office remembers your toolbars & prefs, and it
won't solve the problem. Thanks again for the help.

"Daniel.C" wrote:

Importantly: When I run Excel in Safe Mode, the field list works perfectly!

Try renaming Excel12.xlb or put it in another folder. With XP home, it
is located :
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel
(change USERNAME)
Daniel