Pivot table field list doesn't appear

[donkrafft]

The field list does not appear when I create a pivot table in Excel 2007. It works properly if I start Excel in safe mode. I have toggled the field list button in the PivotTable Tools show/hide ribbon and I tried repairing Office 2007 from the control panel. I’ve also searched the Internet for solutions without success.

I would appreciate any help.

Thanks,

Don

 

[donkrafft]

Just learning the rules.

This question is cross-posted in the excel forum at:
http://www.excelforum.com/excel-general/708899-pivot-table-field-list-doesnt-appear.html

Thanks,

Don

 

[xenou]

How about right-clicking in the pivot table, and selecting "show field list" from the short menu?

ξ

 

[donkrafft]

Hi ξ,

Yes I tried that to no avail. I'm also trying to work out how to specify the fields without the field list using field settings (right click > value field settings) and formulas from the pivot table tools ribbon but I haven't been successful there either.

Thanks,

Don

 

[xenou]

Sounds very bizarre. There's a pivot table "layout" option in when creating one in XL2003 - maybe that's another way to see the fields (not sure if this is in XL2007).

You might try a test on a very small and simplified set of data - in case its something about your particular dataset that throws it off.

 

[donkrafft]

hi http://www.mrexcel.com/forum/member.php?u=75092xenou,

I don't see a "layout" option when I create the pivot table in XL2007. I am using a test spreadsheet that I created from scratch. It has a single worksheet with a test table with five columns and eleven rows. The table is filled with random numbers which have been pasted in as values. It's as simple as it gets.

Thanks for the response.

Don
http://www.mrexcel.com/forum/member.php?u=75092

 

[xenou]

Rat. That sounds bad.

I actually contacted Microsoft once for support and they were surprisingly helpful - as in, stayed with me until the issue was resolved (and followed up with me with a personal call when my chat box was disconnected due to my own fault) - so I think a phone call would be worth a try here.

https://support.microsoft.com/oas/default.aspx?gprid=8753&st=1


This is from the help files - I'm sure you've tried it -

If you don't see the PivotTable Field List, make sure that you click the PivotTable or PivotChart report. If you still don't see the PivotTable Field List, for a PivotTable report, on the Options tab, in the Show/Hide group, click Field List, and for a PivotChart report, on the Analyze tab, in the Data group, click Field List.

I couldn't find any support articles related to Excel 2007 Pivot Tables but your issue seems worthy of attention from Microsoft.

 

[xenou]

This looks very promising (with a link to another thread also):
http://forums.techguy.org/business-applications/861702-solved-excel-2007-pivot-table.html

Wierd problem here (not sure - could be related to your situation):
http://www.access-programmers.co.uk/forums/showthread.php?t=150422

 

[donkrafft]

Hi xenou,

Thanks for the leads. They solved the problem. The issue was an Excel12.xlb file, apparently from a previous version of Excel, that was in the XLSTART folder. Somehow that caused the pivot table field list to disappear. I removed it and the problem went away.


I had searched the Internet extensively for a solution and didn't come across the items that you found. You must have the touch with the search phrase.

Thanks again!

Don

 

[xenou]

Great news! Even a blind squirrel finds a nut now and then