Office 2007 / Vista

Pivot Tables: I've added a field to the 'Row Labels' section called
"Assigned Instructor". But when I look at the title of the field in the
Pivot Table itself, it calls the field "Row Labels". Sometimes this happens
to the Column section to. For example, I'll add a field called 'Month' to
the Column Labels section of the PT, but when viewed in the table, it's
called "Column Labels".

Why is that? Why does the name of the field not accurately appear? (I've
gone into the Field Settings dialog box and have confirmed the name of the
field is accurate.)

Those headings appear when the pivot table is in compact form layout. To
change the layout:

Select a cell in the pivot table
On the Ribbon, click the Design tab
Click the Report Layout command
Click 'Show in Outline form' or 'Show in Tabular form'

Access Joe wrote:
Office 2007 / Vista

Pivot Tables: I've added a field to the 'Row Labels' section called
"Assigned Instructor". But when I look at the title of the field in the
Pivot Table itself, it calls the field "Row Labels". Sometimes this happens
to the Column section to. For example, I'll add a field called 'Month' to
the Column Labels section of the PT, but when viewed in the table, it's
called "Column Labels".

Why is that? Why does the name of the field not accurately appear? (I've
gone into the Field Settings dialog box and have confirmed the name of the
field is accurate.)


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com