Forum Discussion
Pivot Table gives wrong sum after using "Remove Duplicates" for Excel Tables on the source table
I was following a youtube tutorial on Tables, and from an example table, It seems like a value from a deleted row is still part of a sum in a pivot table. I am referring to a duplicated row (wit...
Found the "refresh button" and it did fix the sum. Thanks!
It's interesting though that I had to do a refresh even if the pivot table was created after excel deleted the row.
I would suggest that you already had a pivot table based on the same data source and created a second one.
The Point is, that Excel creates a Pivot Cache in that moment the first Pivot Table is created. Excel then copies all Data from the Data Source into the Pivot Cache and closes the Connection.
Every additional Pivot Table which then will be created in Future will take the same Pivot Cache as its Data Basis.
Thats why the deletion of a row didnt take effekt unless you refresh the formerly created cache.
Best regards
Lars Küster