Are the field names duplicated? Does the source range have more than one
column with a given header, or is a field used multiple times in an area
of the pivot table?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


SunshineX wrote:

My pivot tables work fine for a while,
then when I refresh them ,
sometimes a number 2 is added to some of the field entries
why?