Page 12 of 16PREVNEXT

PivotTable II: Swing into action with PivotTable reports

Data before and after being refreshed

Callout 1 Original sales figures for Peacock.
Callout 2 Updated sales figures for Peacock after refreshing data.

Now it's Monday morning and time to hand off the PivotTable report to your manager. But wait a minute, there's a last minute change in the source data (Peacock made yet another sale), and now the report is incorrect!

Not to worry, it just takes a second to get the changes into the report. You would click the Refresh Data button Button image on the PivotTable toolbar to update the report with the changes.

Page 12 of 16PREVNEXT