Pivot table not updating correctly


01-Nov-2019 21:37

While you think that you are directly linked to the source data, in reality, you access the pivot cache (and not the source data) when you make changes in the pivot table.This is also the reason you need to refresh the pivot table to reflect any changes made in the data set.

pivot table not updating correctly-33

aaron dating eckhart mormon

Your data can be in the same workbook, some other workbook, or an external database.

Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it.