Forum Discussion
Field List in Pivot table not showing
Field list is not showing in my pivot table even after clicking show field list. I am using office 365.
Then it might an issue in my excel setting. I can't even see the status bar at the bottom, I can select sum, count, average but won't show the sum or count when I select the data. Do you have any idea about the setting issue?
See the screen shot the pivot table which didn't show the fields though I have selected the field.
Do you have multiple monitors? If so, try disconnecting all except the main one temporarily to see if the field list reappears on the main monitor.
Something else to try:
- Click anywhere in the pivot table.
- Press Alt+F11 to activate the Visual Basic Editor.
- Press Ctrl+G to activate the Immediate window.
- Type or copy/paste the line shown below.
- With the insertion point anywhere in that line, press Enter.
- Press Alt+F4 to close the Visual Basic Editor.
CommandBars("PivotTable Field List").Position = 2- Well, I tried all these options still unsuccessful.