question on pivot table

i have a column which states months. Before i had abbreviations for the
months and now i want them to be full names. when i changed them the
drop down list for the month field in the pivot table shows the
abbreviated names as well. is there any way to get rid of them without
making a new pivot table.

thanks


---
Message posted from http://www.ExcelForum.com/

Hi

Remove the month field from the pivot table, then refresh
and then add the month field again.
Hopefully this helps.

regards

-----Original Message-----
i have a column which states months. Before i had
abbreviations for the
months and now i want them to be full names. when i
changed them the
drop down list for the month field in the pivot table
shows the
abbreviated names as well. is there any way to get rid of
them without
making a new pivot table.

thanks


---
Message posted from http://www.ExcelForum.com/

.

thanks, but i already tried that. no luck.


---
Message posted from http://www.ExcelForum.com/

There's code here that you can use to remove the old items:

http://www.contextures.com/xlPivot04.html

Keyur wrote:
i have a column which states months. Before i had abbreviations for the
months and now i want them to be full names. when i changed them the
drop down list for the month field in the pivot table shows the
abbreviated names as well. is there any way to get rid of them without
making a new pivot table.

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