Hi,

I have pivot tables that seem to pull the wrong value from my data series.
The value in question is a string describing the name of a report "Motor
Drives - WW - 2005". My pivot table pulls this value and adds the value 2 to
it. E.g. "Motor Drives - WW - 20052". When I drill to detail, the correct
value is shown.

Is this an Excel bug? Has anyone else encountered it and know how to fix this?

Thanks,
Ra

If the data is internal to te workbook, could you send me a copy ? I'd love to see it

I'm having this exact problem. The result should be 708 but the pivot table is showing 7082. There are no 7082 figures anywhere in my workbook.