fields names do not show in excel 2007 pivot table fields list

M

marlo17

I use both excel 2007 and excel 2003 with xp professional. when I do pivot
tables in exce 2007,the pivot table fields list is empty of field names.
There is nothing to drag to different areas of pivot table. I have tried
anything I could think of. However, that same .xls file works ok in excel
2003!
 
S

Shane Devenshire

Hi,

If there are not field in the Pivot Table Field List it suggests you may
have the field list portion of the Pivot Table Field List (PTFL) suppressed.
Open the button in the top right corner of the PTFL and make sure the first
option is selected.

Cheers,
Shane Devenshire
 
M

marlo17 via OfficeKB.com

Shane said:
Hi,

If there are not field in the Pivot Table Field List it suggests you may
have the field list portion of the Pivot Table Field List (PTFL) suppressed.
Open the button in the top right corner of the PTFL and make sure the first
option is selected.

Cheers,
Shane Devenshire
Click to expand...
Hi,Shane
Do you mean the PTFL option above the SHOW/HIDE BUTTON? I have tried that,
but NO fields labels.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 and refresh pivot table methodology 0
Problem inserting calculated pivot fields into Pivot Table (2007) 1
I don't see the Pivot table field list window 1
Excel 2000 Pivot table in Excel 2007 5
Excel 2007 pivot table using analysis services cube as data source 0
My new pivot table doesn't save 1
pivot table loosing decimals (vba) 1
Pivot Table calculated field error 2

Top