PowerPivot: Install the PowerPivot Add-In for Excel

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.

You will need...

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.

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.


See Also


External Links

Leave a Comment
  • Please add 4 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Carsten Siemens edited Revision 21. Comment: Fixed misspelling and added tag: has comment, has TOC

  • Fernando Lugão Veltem edited Revision 17. Comment: the link .NET Download page was broken. correct url

  • Ed Price MSFT edited Revision 7. Comment: Added links to the PowerPivot YT playlists.

  • Ed Price MSFT edited Revision 5. Comment: Updated MSDN link.

  • Ed Price MSFT edited Revision 4. Comment: Added a link to PowerPivot Overview.

  • Ed Price MSFT edited Revision 3. Comment: Added horizontal lines.

  • Ed Price MSFT edited Revision 1. Comment: Added See Also section and more info.

  • Ed Price MSFT edited Original. Comment: Added External Links.

Page 1 of 1 (8 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price MSFT edited Original. Comment: Added External Links.

  • Ed Price MSFT edited Revision 1. Comment: Added See Also section and more info.

  • Ed Price MSFT edited Revision 3. Comment: Added horizontal lines.

  • Ed Price MSFT edited Revision 4. Comment: Added a link to PowerPivot Overview.

  • Ed Price MSFT edited Revision 5. Comment: Updated MSDN link.

  • Ed Price MSFT edited Revision 7. Comment: Added links to the PowerPivot YT playlists.

  • Loved the movice, great article!

  • Anyone have success installing PowePivot on Windows 7 64bit?

  • Kevin,

    You can try asking this in a PowerPivot forum.

  • Fernando Lugão Veltem edited Revision 17. Comment: the link .NET Download page was broken. correct url

  • This is good one but cannot use Excel 2007 to interact with a PivotTable :(.. high time to upgrade the office 2007 to 2010

  • perfecto

  • Carsten Siemens edited Revision 21. Comment: Fixed misspelling and added tag: has comment, has TOC

Page 1 of 1 (13 items)