Microsoft Office Tutorials and References
In Depth Information
Understanding the Internal Data Model
Add your Tables to the internal Data Model
Each 2013 workbook has an internal Data Model that (by default) is exposed as a connection called
ThisWorkbookDataModel when you add data sources to it. You can add your newly created Tables to
the internal Data Model using the Workbook Connections dialog box. Follow these steps:
1. Go to the Ribbon, click the Data tab, and select Connections.
2. In the Workbook Connections dialog box, click the drop-down arrow beside the Add button
and select Add to the Data Model (see Figure 17-5).
Figure 17-5: Open the Workbook Connections dialog box and select Add to the Data Model.
The Existing Connections dialog box opens, as shown in Figure 17-6.
3. Click the Tables tab, choose the table you want to add, and click OK.
Figure 17-6: Choose a table to add and click OK.
4. Repeat Steps 2 and 3 for each Table you want to add to the internal Data Model.
After adding all your tables, the Workbook Connections dialog box shows a connection
called ThisWorkbookDataModel, listing all the data sources associated with it.
As you can see in Figure 17-7, you now have your two tables in the internal Data Model.