Wikis - Page Details

First published by Ed Price - MSFT (aMicrosof)
When: 12 Apr 2010 2:56 PM
Last revision by Carsten Siemens (eMicrosoft Partne)
When: 25 May 2013 2:45 PM
Revisions: 23
Comments: 13

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

PowerPivot: Install the PowerPivot Add-In for Excel

PowerPivot for Excel is a free download that significantly expands the data analysis capabilities of Excel. PowerPivot is made up of the Excel free add-in and the SharePoint server component.

Video tutorial by Michele Hart, Technical Writer for Microsoft SQL Server.

View all the PowerPivot videos on YouTube in the official SQL Server PowerPivot playlist.

Hardware Requirements:
Software Requirements
See Also
External Links

You will need...

.NET Framework 3.5 SP1 (already on Windows 7): http://microsoft.com/net/Download.aspx
Microsoft Office 2010 (64 bit recommended)

When installing Office, be sure to install Office Shared features.

To install PowerPivot, go to http://powerpivot.com.

To verify that the add-in installed, open Excel, and then click the PowerPivot tab on the Excel ribbon. The PowerPivot window opens over the Excel window.

Hardware Requirements:

Component	Minimum Requirements
Processor	500 MHz 32-bit or 64-bit processor
RAM	2 to 4 GB of RAM. The add-in consumes approximately 25 MB of RAM. An additional 33 MB is consumed when the first PivotTable is added to the worksheet. Additional RAM is required for PowerPivot workbooks. The amount of RAM required will vary depending on the workbook you create. PowerPivot supports files up to 2GB in size. The 64-bit version of PowerPivot enables you to work with up to 4GB of data in memory, and the 32-bit version enables you to work with up to 2GB of data in memory.
Disk space	100 MB disk space is required for the program files. Additional disk space is required to store data files. Although the files contain compressed data, you might require significant disk space if you create numerous workbooks that contain a very large amount of data. There is no way to know advance what your disk space requirements will be. Be sure to monitor disk space consumption as you create and save files to ensure you have sufficient space.

Component

Minimum Requirements

Processor

500 MHz 32-bit or 64-bit processor

RAM

2 to 4 GB of RAM. The add-in consumes approximately 25 MB of RAM. An additional 33 MB is consumed when the first PivotTable is added to the worksheet. Additional RAM is required for PowerPivot workbooks. The amount of RAM required will vary depending on the workbook you create.

PowerPivot supports files up to 2GB in size. The 64-bit version of PowerPivot enables you to work with up to 4GB of data in memory, and the 32-bit version enables you to work with up to 2GB of data in memory.

Disk space

100 MB disk space is required for the program files. Additional disk space is required to store data files. Although the files contain compressed data, you might require significant disk space if you create numerous workbooks that contain a very large amount of data. There is no way to know advance what your disk space requirements will be. Be sure to monitor disk space consumption as you create and save files to ensure you have sufficient space.

Software Requirements

PowerPivot for Excel can be installed on a computer that has 32-bit or 64-bit Excel 2010. If you have installed the 32-bit version of Excel, you must install the 32-bit version of PowerPivot for Excel. Likewise, if you have installed the 64-bit version of Excel, you must install the 64-bit version of PowerPivot for Excel.

Operating system	Windows XP SP3 (32-bit only), Windows Vista SP2, Windows 7, Windows Server 2003 R2 with MSXML 6.0 (32-bit only), Windows Server 2008 SP2, or Windows Server 2008 R2 (64-bit only).If you are using Windows Vista or Windows Server 2008, you must also install the Platform Update that is available from http://support.microsoft.com/default.aspx/kb/971644.
Windows features	Microsoft .NET Framework 3.5 SP1 (Install before installing Office)
Excel version requirements	Excel 2010 (32-bit or 64-bit) is required to install PowerPivot for Excel.
Office features	Office Shared Features must be installed with Excel 2010. .NET Programmability Support, in Microsoft Excel, must also be installed.