Microsoft Office Tutorials and References
In Depth Information
Updating a PivotTable or PivotChart
For Your Information: Changing the Data Source in a PivotTable
You can select a different data source for a PivotTable. For example,
you can connect to data feeds ( New ! ) like OData, Windows Azure
DataMarket, and SharePoint. Click the PivotTable report, click the Ana-
lyze tab, click the Change Data Source button, click Change Data
Source, click the Select A Table Or Range option and specify a range,
or click the Use An External Data Source option and specify a connec-
tion, and then click OK. You can refresh PivotTable or PivotChart data.
Click the PivotTable report, click the Analyze tab, and then click the
Refresh button. Click the PivotChart report, click the Analyze tab, and
then click the Refresh button.
Search JabSto ::




Custom Search