Create a Pivot Table Using Excel's Internal Data Model

Excel Sales Forecasting For Dummies

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:

Choose Insert→PivotTable from the Ribbon. The Create PivotTable dialog box opens.
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.
On the Tables tab, select Tables in Workbook Data Model, and then click the Open button. You return to the Create PivotTable dialog box.
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.

About This Article

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.