After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.

How to Data Model in Excel Spreadsheets. Enable PowerPivot Add-In. Open Excel and go to the File tab. Select Options from the menu. In the Excel Options dialog box, click on Add-Ins.

To compare and contrast dimensional modeling in Excel with other tools and platforms, you need to evaluate several factors. This includes the data source, such as how you connect to and import ...

You probably know that, when you are importing data from multiple tables in SQL Server into the Excel Data Model in Excel 2013 using Power Query, Power Query will automatically create relationships ...