Missing Field List when creating Pivot Table

Question

I cannot get the Field List to appear when creating a Pivot Table. The button is not operative on the toolbar ribbon and it does not appear when selected via right click on the mouse. The effect being that I cannot create a Pivot Tabel,

Answer 1

One of these might help:

Were you recently using two monitors or a monitor with a laptop and have now switched to one monitor or just the laptop, or has the field window been moved from the viewable area?

Select a cell within the range of your pivot table.

Press F10

Press CTRL+TAB

Press CTRL+SPACE

Press M

Press the Up Arrow key

Move your mouse around and left click to drop the window somewhere you can see it.

Are macros enabled in your workbook, or are you prompted to run macros when opening the workbook?

Try running this:

Sub Macro99()

ActiveWorkbook.ShowPivotTableFieldList = True

End Sub

Answer 2

The trick to delete the Excel12.xlb file in the C:\Users<YourUserName>\AppData\Roaming\Microsoft\Excel folder was magic for me.

I was kind of desperate to see the Pivot Table Fields again and this worked beautifully!

Thanks a million for the help

Answer 3

What was preventing Excel to show Fields List when selecting the related pivot table was that the initialization file Excel12.xlb was launched twice: one from my hApplication Data\Excel\XLSTART folder and one from my Application Data\Excel folder.

Removing the one from the XLSTART folder did the trick immediately at the next Excel startup.

Of course, having tried all other possible causes exposed here did not resolve the issue: looking for an hidden/masked Fields List windows, resetting the windows and command bars with a VBA macro,etc.

Only starting Excel in safe mode was successful. That's what lead the resolver to post this simple trick. God bless him! Here's his post.

Alternatives solutions for different root causes are discussed via the following links:

http://forums.techguy.org/business-applications/861702-excel-2007-pivot-table-field.html

http://forums.techguy.org/business-applications/855097-excel-2007-pivottable-field-list.html

Cheers from France

Answer 4

I had this problem too in Excel 2010 and found a simple solution:

Make sure the cursor is in a cell in the pivot data when you right click the mouse. Then you'll see "show field list" in the context menu.

You can also enable it in the Pivot Table Tab>Options tab, but you HAVE to have the cursor in the pivot data first.

HTH,

Emma

Answer 5

I am having the same problem while using excel 2010.  And yes, I am using two monitors connected to my laptop.  Not only can I not see the filed list while creating PivotTables, when I right-click on any cell while in the spread sheet, the shortcut menu does not appear.

Please advise

Maurice