The data field names can't be exactly the same as the field names in
source table. However, you can use the field name, and add a space
character at the end:

In the Pivot Table, select a cell that contains the data field name,
e.g. Sum of Guitars
Type a new name, e.g. Guitars, and type a space character at the end
Press the Enter key to complete the change

~D~ wrote:
> This is for a test so here is my example:
>
> I created a pivot data chart and the items were:
>
> drum
> guitar
> keyboard
>
> followed by the months of the year
>
> I dropped the months in the series field and that was fine. I then took
> drum, guitar and keyboard and it reads "sum of guitars" "sum of keyboards"
> "sum of drums".
>
> I don't want the "sum of" to appear ..I just want "guitars" "keyboards"
> "drums".
>
> Thank you.
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html