Excel Power Pivot & Power Query For Dummies, 2nd Edition
Book image
Explore Book Buy On Amazon
In certain instances, you may want to create a pivot table from scratch using Excel's existing Internal Data Model as the source data. Here are the steps to do so:
  1. Choose Insert→PivotTable from the Ribbon. The Create PivotTable dialog box opens.

    Create-PivotTable-dialog

  2. Select the Use an External Data Source option, as shown, and then click the Choose Connection button. You see the Existing Connections dialog box, as shown.

    Use-an-External-Data-Source

  3. On the Tables tab, select Tables in Workbook Data Model, and then click the Open button. You return to the Create PivotTable dialog box.
  4. Click the OK button to create the pivot table. If all goes well, you see the PivotTable Fields dialog box with all tables that are included in the Internal Data Model, as shown.

    PivotTable-Fields-2

About This Article

This article is from the book:

About the book author:

Michael Alexander is a Microsoft certified application developer and author of several books on advanced business analysis with Microsoft Access and Microsoft Excel. He has been named a Microsoft MVP for his ongoing contributions to the Excel community.

This article can be found in the category: