Show Field List in Pivot does not work

  • Thread starter Thread starter RSolti
  • Start date Start date
R

RSolti

When I click 'Show Field List' in my toolbar to adjust a pivot table, nothing
happens. Excel acts like it is not active. It is not grayed out, just does
not respond. Is there a VB script I can run to fix?
 
Thanks - that worked

Jan Karel Pieterse said:
Hi RSolti,


Click anywhere inside the pivot table, does that change things?
If not, try issuing this command in the immediate window of the VBE (alt-F11,
control+g):

Application.CommandBars("PivotTable Field List").Enabled=true

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
Click to expand...
 
Jan I have the same problem as RSolti but I do not understand the solution (I
don't understand what VBE is!). Can you spell it out in more detail please.

Many Thanks
 
Jan

Worked like a dream - many thanks

Ian

Jan Karel Pieterse said:
Hi Ian,


VBE stands for Visual Basic Editor, which is where Excel lets you enter and edit
macros.
Like I wrote originally, you get where you need to do the magic by hitting Alt+F11
(this opens the VBE) and control+g. This takes you to a small window which is known
as the immediate window. You can type VBA commands in there which get executed once
you hit enter. Then you type this command followed by an enter:

Application.CommandBars("PivotTable Field List").Enabled=true

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
Click to expand...
 
Back
Top