To retrieve external data fields, you use Microsoft Query. To start MS Query and run the Query Wizard, click Get Data. Follow ...

To retrieve external data fields, you use Microsoft Query.   To start MS Query and run the Query Wizard, click Get Data. Follow the Query Wizard steps to view and organize your data. When you click Finish in the Query Wizard, or the Return Data To Microsoft Office Excel button in MS Query, you return to the PivotTable and PivotChart Wizard.