PDA

View Full Version : How to start PowerPivot



whoiswct
2012-11-24, 01:41 PM
I download PowerPivot (Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010). Restart PC. But I don't know where to find this add-on.
Pls help.

Bob Phillips
2012-11-24, 11:14 PM
Goto File>Options>Addins, Select COM Addins from the Manage dropdown, click Go and check the PowerPivot for Excel item.

whoiswct
2012-11-25, 08:09 AM
Seem cannot load. My office is 2010.
919
any advise?

Bob Phillips
2012-11-25, 08:55 PM
Do you have the Net 4 client and VSTOR?

Ken Puls
2012-11-26, 05:05 AM
The official steps from Microsoft are:

1. Install .NET Framework 4.0 (http://go.microsoft.com/fwlink/?LinkId=232658) and Visual Studio 2010 Tools for Office Runtime (http://go.microsoft.com/fwlink/?LinkId=232657).

2. If you are running Windows Vista or Windows Server 2008, install the platform update. (http://go.microsoft.com/fwlink/?LinkId=186051)

3. Install Microsoft® Office 2010 (http://go.microsoft.com/fwlink/?LinkId=186053).

4. Install PowerPivot for Microsoft Excel

To my recollection, you have to do all of those. I know that you can go in the order 3, 1, 2, 4, but I'm not sure if you'll need to uninstall PowerPivot first before you install the first components. May be safer to just do that.

Bob Phillips
2012-11-26, 10:46 AM
I know that you can go in the order 3, 1, 2, 4, but I'm not sure if you'll need to uninstall PowerPivot first before you install the first components. May be safer to just do that.

You most definitely do.