- Choose the File option then Options and the option for Add-ins.
- Choose the option for Manage, then COM, then add-ons and Go.
- From there, you will want to choose the box with the Microsoft Office Power Pivot label and select the box marked OK.
- Assuming you did everything right, you will now see a new tab on the primary ribbon with the name Power Pivot.
Import relational data
If you do choose to import relational data, Excel will automatically create a data model once multiple tables have been selected, but only if you do the following:
- Choose the Data option and then the option to Get External Data. This will give you the option to choose an external source that contains the tables you want to work with.
- The resulting window will give you the option to choose the table that you want to select. As you want to choose multiple tables, click the box that lets you select multiple tables and then select your tables.
- Choose the option that makes sense for the way your data is going to be visualized and select the option to confirm. This will generate the data model that you requested, though you can still manipulate it later. This model will then be automatically updated as you manipulate the worksheet. If you rename this model afterward, then you will need to resync everything by repeating the above steps.