In Excel 2010, PowerPivot is an add-in that must be downloaded and installed. In Office 365 Pro and Excel 2013 Pro Plus, the add-in is a part of the default Excel installation setup (which means there is no requirement to install PowerPivot). However, the add-in must be activated before it can be used (see Chapter 10, Visualizing Data with Power View, for details on enabling the add-in in Excel 2013).
The 2010 add-in can be downloaded from the Microsoft download center (free of charge) using the following URL:
http://www.microsoft.com/en-us/download/details.aspx?id=29074
Although the installation is relatively straightforward once the installation file is obtained, the downloaded file must match the installed version of Excel (that is, whether Excel is operating in 32-bit or 64-bit mode). This can be checked by selecting the Help option from the File tab (in Excel), as shown in the following screenshot:
In the About Microsoft Excel section, we can see that this version of Excel is a 64-bit version (and hence, we must install the 64-bit version of PowerPivot).
The download page (from the provided URL) will look like the following screenshot:
When the Download button is clicked, you are prompted to choose the file to download, as shown in the following screenshot.
The file with the name ending with _amd64.msi
—the middle one in the following screenshot should be installed for the 64-bit version of Excel and the other file (_x86.msi
) should be downloaded and installed on systems having the 32-bit version of Excel:
Once the file has been downloaded, we can execute it by double-clicking on it, however, Excel must be closed during the installation of PowerPivot. Note that, depending on your user account permissions, you may be prompted to run the installation process as an administrator, or the file will change the computer's settings. Run the file by simply clicking on the Run button.
The installation process does not require any advanced user interaction. All you have to do is accept the terms and license agreement and click on the Install button. Once the installation is successfully completed, the installer will provide a confirmation window, as shown in the following screenshot. Simply click on Finish to complete the process.
When Excel is opened, the PowerPivot tab will appear in Excel's menu bar.