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?

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?

"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 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?

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