question on pivot table

[Keyur]

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

thank

 

[Guest]

Hi

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

regards

 

[Keyur]

thanks, but i already tried that. no luck

 

[Debra Dalgleish]

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

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