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. Or, if you like keyboard shortcuts, press Alt+F5.

To ensure that your PivotTable is sorted whenever you open the file, click a cell within the table, click the Options tab under PivotTable Tools, and then click Options in the PivotTable group. In the PivotTable Options dialog box, click the Data tab. Then select the Refresh Data When Opening The File check box, and click OK.




2007 Microsoft Office System Inside Out
2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)
ISBN: 0735623244
EAN: 2147483647
Year: 2007
Pages: 299

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net