Refreshing Pivot Values Manually
If a Pivot section has been designed so that pivot values can be refreshed manually, you can request an immediate refresh to the current section.
To refresh pivot values manually, click anywhere on the pivot and select Refresh Pivot on the shortcut menu.