Analyzing Microsoft Excel 2010 Data with PivotTable Reports
- 8/31/2010
- Introducing PivotTables
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
Refreshing a PivotTable
Because users often generate PivotTables from large volumes of data (and in many cases that data resides on external servers), Excel doesn’t automatically update PivotTables when their source data changes. To refresh a PivotTable, right-click any cell within it, and click Refresh. Alternatively, under PivotTable Tools, click the Options tab, and then click Refresh in the Data group. If you prefer keyboard shortcuts, press Alt+F5.
To ensure that your PivotTable is up to date whenever you open the file, right-click any cell in the table, choose PivotTable Options from the shortcut menu, and click the Data tab in the PivotTable Options dialog box. Select the Refresh Data When Opening The File check box, and then click OK.