Jul 28 2018 04:27 PM
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 (with date 04/27/2012 in screenshot) that excel deleted after identifying it as a duplicate.
After deletion, however, it still gives a sum in a Pivot Table as if the duplicate was not deleted even when Excel says it did.
Am I missing something here?
Jul 28 2018 04:31 PM
Did you refresh Pivot Table?
Jul 28 2018 04:34 PM
I created it after deletion.
I dont seem to have a "refresh" button.
Jul 28 2018 04:38 PM
BTW I am using Office Professional Plus 2010
Jul 28 2018 06:10 PM
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.
Jul 29 2018 04:20 AM
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