Pivot table field list is missing

Question

The field list option is selected. Have renamed "Excel12.xlb". The field list is working well if running Excel in safe mode but not in normal Excel. Have tested options provided in the "troubleshoot Excel 2007 startup problem" but problem still exist. Can anyone help please.

Answer 1

If it works in Safe mode but not in normal use, I would suspect an add-in or a program loaded at startup has disabled it. 

In normal mode, Alt+F11 to the VB editor, Ctrl+G to the immediate pane and type

?Application.CommandBars("PivotTable Field List").Enabled

and hit Enter if it says False, type (or paste) the following line:

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

and hit Enter.

Does it now behave correctly?

If so, disable add-ins (via Office Button > Add-Ins) and remove all workbooks from your XLSTART folders (which can be found by typing the following in the VB editor immediate window:)

?Application.Path & "\XLSTART"

?Application.StartupPath

?Application.AltStartupPath

Restart Excel and check it still behaves correctly.

You could then add back your add-ins and startup programs until you find the culprit.

Answer 2

In the VB editor, immediate window enter

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

with no question mark this time

Answer 3

Very thanks for your reply.

I tried "Application CommandBars("Pivot Table Field List"). Enabled=true, it returns False. 

I have already deleted all add-ins items. I do not have any item in the "\XLSTART" folder, one item "Excel12.xlb" in the StartupPath and no AltStartupPath. But the field list still highlighted but not functioning.

I found that the Excel14.xlb file was causing the problem.  This .xlb file was in my C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART folder .

Answer 4

thanks alot, it's working now.

Answer 5

Very thanks for your reply.

I tried "Application CommandBars("Pivot Table Field List"). Enabled=true, it returns False. 

I have already deleted all add-ins items. I do not have any item in the "\XLSTART" folder, one item "Excel12.xlb" in the StartupPath and no AltStartupPath. But the field list still highlighted but not functioning.