Excel 2007 Pivot table Problem - Change source but pivot doesn't update

[lewdow]

Hi,

I have a large table of source data in excel 2007 which I have pivoted.

I am consequently going through changing some of the data in one column (it contains several variations of names complete with typing errors etc).

I then right click on the pivot and refresh, but the old miss spelt names still appear in the pivot.

Even rebuilding the pivot doesn't help nor does closing and reopening and even shutting down and restarting....

Anyone got any ideas at all?

Thanks

Lewis

 

[Andrew Poulsom]

Look here:

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

 

[lewdow]

perfect - thanks very much!