Microsoft PowerPivot for Microsoft
Excel 2010 provides ground-breaking technology; fast manipulation of large data
sets, streamlined integration of data, and the ability to effortlessly share
your analysis through Microsoft SharePoint.
Please make sure that Microsoft SQL Server 2012 SP1 Power Pivot is
installed in your computer.
If you have Power Pivot installed
in your computer, you would see “Power Pivot” tab once you open any excel
spreadsheet.
If you are sure that Power Pivot is
installed but you still don’t see the “Power Pivot” tab then use file options
to enable it.
Go to File à Options
Then go to “Add Ins”. Select “COM
Add-Ins” under Manage drop down and click on “Go”
Ensure Power Pivot is selected as
shown below. Click on OK.
In order to check the version of
Power Pivot installed - open any Excel spreadsheet and click on “Settings”
button under “PowerPivot” tab.
You will see version listed as
below. The current version is “11.0.3000.0”.
If yours is anything lesser, then it is recommended to install the latest one.
Go to http://www.microsoft.com/en-us/download/details.aspx?id=29074 and download appropriate file. If you have 32-bit of
Office installed then download one with x86. If you have 64-bit of Office installed then download x64
file.
To check which version of Office is
installed in your computer, open any Office application (Word, Excel, Power
Point etc…) and go to File à
Help. You will see the version listed as below.
Once you click on the download link
(http://www.microsoft.com/en-us/download/details.aspx?id=29074), you will be prompted to choose the file to be downloaded.
It is recommended to first
UNINSTALL the existing Power Pivot before you INSTALL the new one. So while the
file is being downloaded, Go to Start à
Control Panel à
and click on “Program and Features”. Check if you have “Microsoft SQL Server
2012 Power Pivot for Excel 32-bit (or 64-bit)” installed.
If you see any version of Power
Pivot installed. Right click and click on “Uninstall”.
Now after the download of relevant
file (x86 or x64 Power Pivot) is complete, locate the exc file downloaded and
double click on it.
Click on “Run” when prompted.
Click on “Next”
Go through the wizard to install
Power Pivot.
TIP: During your work if you feel like PowerPivot is
responding slowly, one way to reset is to Go to file option à Add Ins and uncheck Power
Pivot option and then go back and check it again.
TIP: If above tweak doesn’t work efficiently, then you
might try to uninstall and install Power Pivot again.
There are a few tutorial and videos at http://www.microsoft.com/en-us/bi/powerpivot.aspx
to help you learn and quick start with Power Pivot solutions.