This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Get the Correct Version of PowerPivot
PowerPivot comes in two client versions. The version that you download has to match your version of Excel 2010. Most people will have the 32-bit Excel 2010 installed. Even if you have a 64-bit computer, the Office 2010 installation process is heavily skewed towards installing the 32-bit version.
In Excel 2010, go to File, Help. On the right side of the screen, look for About Microsoft Excel. A tag at the end of the version number will indicate if you have 32-bit or 64-bit Excel installed.
Figure 944 This is 64-bit Excel.
When you go to www.PowerPivot.com to download the add-in, either download the 64-bit or the 32-bit version. While the 64-bit says “64", the 32-bit says “86".
Figure 945 Download the correct version to match your Excel 2010.
Once you download and install PowerPivot, you will have a PowerPivot tab in the Ribbon, somewhere beyond the View tab.
Figure 946 After a successful install, you will have a PowerPivot tab in the ribbon.
Gotcha: PowerPivot will not work with Excel 2007 or earlier. They had to add a lot of internal code to Excel to get PowerPivot to run. That code is only present in Excel 2010. Do I think they will ever go back and add that code to Excel 2007? No. It would be too much work, and the team is busy developing good things for Excel 2014.
Gotcha: There is a PowerPivot tab in the Excel ribbon. There are also Home, Design, and Linked Table tabs in the PowerPivot window. You have to click the PowerPivot Window icon on the PowerPivot ribbon tab in Excel to get to the Home, Design, and Linked Table tabs in PowerPivot.
Figure 947 An icon on the PowerPivot ribbon opens PowerPivot.