In order to not forget what I learn or discover, I write it down … here. Much of the content will be a result of my daily interactions with business users and other BI devs. Office Shared Features must be installed with Excel 2010.NET Programmability Support, in Microsoft Excel, must also be installed.As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. NET Framework 3.5 SP1 (Install before installing Office)Įxcel 2010 (32-bit or 64-bit) is required to install PowerPivot for Excel. 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 Likewise, if you have installed the 64-bit version ofĮxcel, you must install the 64-bit version of PowerPivot for Excel. If you have installed the 32-bit version of Excel, you must install the 32-bit version of PowerPivot for Excel. PowerPivot for Excel can be installed on a computer that has 32-bit or 64-bit Excel 2010. Be sure to monitor disk space consumption as you create and save files to ensure you have sufficient space. There is no way to know advance what your disk space requirements will be. Although the files contain compressed data, you might require significant disk space if you create numerous workbooks that contain a very large amount Additional disk space is required to store data files. 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.ġ00 MB disk space is required for the program files. PowerPivot supports files up to 2GB in size. The amount of RAM required will vary depending on Additional RAM is required for PowerPivot workbooks. An additional 33 MB is consumed when the first PivotTable is added to the worksheet. The add-in consumes approximately 25 MB of RAM.

Hardware Requirements ComponentĢ to 4 GB of RAM.

The PowerPivot window opens over the Excel window. To verify that the add-in installed, open Excel, and then click the PowerPivot tab on the Excel ribbon. When installing Office, be sure to install Office Shared features.

Microsoft Office 2010 (64 bit recommended for Windows versions 64 bit).

NET Framework 3.5 SP1 (already on Windows 7):

Power pivot excel 2013