It has been a long road, but all of the pieces were completed today: Nov 18, 2009. Here is a complete collection of the links that you will need to grab PowerPivot.
Download PowerPivot for Excel 2010 (the client)
- Prerequisites
- PowerPivot for Excel supports 32-bit or 64-bit machine
- PowerPivot requires 2-4 GBs of RAM — The amount of memory needed will depend on the PowerPivot solution you are designing
- Requires Windows XP, Windows Vista or Windows 7
- If you are running a version of Windows other than Windows 7, you will need to download and install the .NET Framework 3.5 SP1 from here:
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyID=ab99342f-5d1a-413d-8319-81da479ab0d7
- Register to download the Microsoft Office 2010 Beta
- Download PowerPivot for Excel 2010
- Download PowerPivot for Excel 2010 from here:http://go.microsoft.com/fwlink/?LinkID=155905&clcid=0×409
- Important: If you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot. If you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot. The versions are not interchangeable.
- Install and configure PowerPivot for Excel 2010
- To install PowerPivot for Excel 2010:
- Open the folder where you downloaded PowerPivot for Excel 2010
- Double-click the PowerPivot_for_Excel.msi file and follow the steps in the wizard
- After the installation is complete, click Finish
- Click the Windows Start button, select All Programs, select Microsoft Office 2010, and select Microsoft Excel 2010
- When Excel 2010 starts, a message appears asking if you want to install PowerPivot, click OK.
- After installation completes, the PowerPivot tab appears in the Office 2010 ribbon.
- Click here to learn how to get started using PowerPivot to Excel
(Note: You do not need to install the server components to try out PowerPivot. All you need is the client components above and you are off designing models, importing data, and generating reports.)
Download PowerPivot for SharePoint (the server)
- Download SQL Server 2008 R2 November CTP
- Register and download SharePoint 2010 Beta
- Configure PowerPivot for SharePoint
- Instructions to install and configure PowerPivot for SharePoint 2010
- Click here to learn more about Self-Service Business Intelligence


I get an error “Failed to retrieve data from ‘Incidents June to Dec 2011$’. Reason: Unexpected error from external database driver (1).”; any help on where I am going wrong ?
I also get the odd time where it will import and say ’successful’ but zero records appear, are the two related ?