Requirements:
- Microsoft .NET Framework 4.0 (or newer). http://go.microsoft.com/fwlink/?linkid=229476
- Excel 2010.
- Office Shared Features must be installed with Excel 2010. (To add/check, go to Control Panel | Program & Features | MS Office 2010 | Change ...)
- .NET Programmability Support, in Microsoft Excel. (Idem to add/check)
- Visual Studio 2010 Tools for Office Runtime (http://go.microsoft.com/fwlink/?linkid=229475) (Install before or after Office, but before using PowerPivot for Excel).
Download Power Pivot from https://www.microsoft.com/en-us/download/details.aspx?id=29074
Run MSI installer as administrator.
Upon succesful installation, open Excel 2010. The PowerPivot tab should appear on the Excel ribbon.
An example to set relationship between 2 worksheets.
- Go to first worksheet, select your table's range.
- In the PowerPivot tab, run"Create Linked Table".
- Repeat for the second worksheet.
- In the PowerPivot window, tab Design, click on "Create relationship".
- Select "from" table and its column, then "related lookup" table and its column. The two columns, of course, must have relationship (one-to-one, one-to-many). Do create.
- Now, in the Excel window, in tab PowerPivot, from one of the worksheet, run "PivotTable | Insert PivotTable".
- Select New worksheet. (or existing, if there exist one already).
---
Notes:
For Windows 64 bit with Office 32 bit, there may be problem with Power Pivot tab doesn't appear.
In this case, try to install "Visual Studio 2010 Tools for Office runtime".
---
