Pivot Refresh vs. Update – is there a real difference?
Quick primer: when I worked on the Excel team, we described most pivot manipulations as “Updates.”
- Changing selections in a slicer or report filter
- Moving a field from rows to columns, or changing its order, etc.
- Adding removing fields to/from the pivot