Installing PowerPivot
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...