Excel 2010 (Office Pro Plus 2010):
If I create a PivotTable and enter a value manually in a Row Label cell, then I can't make the table refresh its data to reflect the source data again. All values in the Value fields stick with the original Row Labels, but the actual value in the Row Labels shows the manually entered value and not the source value.
It doesn't help to change "Number of items to retain per field" to "None" in the PivotTable options and then refresh.
It doesn't help to uncheck "Save source data with file.
I don't want to make a new Pivot, I want to know if it's possible to make the Pivot refresh properly and ignore manual entries that have been done.
See attachment.
Any ideas?
Bookmarks