![]() |
fields names do not show in excel 2007 pivot table fields list
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! |
fields names do not show in excel 2007 pivot table fields list
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 "marlo17" wrote: 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! |
fields names do not show in excel 2007 pivot table fields list
Shane Devenshire wrote:
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 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! Hi,Shane Do you mean the PTFL option above the SHOW/HIDE BUTTON? I have tried that, but NO fields labels. -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 08:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com