Show Field List in Pivot does not work

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

 

[RSolti]

Thanks - that worked

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

 

[IanT]

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

 

[IanT]

Jan

Worked like a dream - many thanks

Ian

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