ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Field Names (https://www.excelbanter.com/excel-discussion-misc-queries/255208-pivot-table-field-names.html)

bamataylor

Pivot Table Field Names
 
In previous versions of Excel when dragging a filed to a Row or Column
position in a Pivot Table it would automatically draw the field name from the
underlying table, in other words if I were to take the field 'Facility Name'
from the source data and make it a row item, the header for that row would be
'Facility Name' In Excel 2007 when I do this it creates a header called
'Row Labels'. The same behaviour takes place for Column Labels. I then have
to type in the field name I want for each Row or Column Header.

Is there any way to have Excel 2007 assume the field name from the
underlying table with as it did with previous versions?


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com