Pivot Table Missing Field List

[Gizmo]

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?

 

[Daniel.C]

Try the following macro :

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

HTH
Daniel

 

[LindaB]

Try the following macro :

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

HTH
Daniel

 

[LindaB]

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]

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?

 

[Baffled]

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!

 

[Daniel.C]

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

 

[Baffled]

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.