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?