PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Client: What happens if I install the wrong ‘bitness’?

Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:

Embedded Analysis Services [...]

Uninstalling PowerPivot does what ?? Arg!!@@!!!

(With my thanks to Fernando Delgado, our excellent setup dev for working up this solution)

After uninstalling PowerPivot for SharePoint, Excel Services and other features in the PremiumSite feature will be disabled. At a certain level for “new server”, this makes sense since turning on and configuring of Excel Services et. al. was part of the [...]

Installation failure: “Could not load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’ . . .

We’ve been hearing reports of this failure for several weeks, but we’ve not been able to get a good repro until a week ago. And it was the most “most reported bug” at TechEd — if there is such a category — but it looks like we have a solution after many hours [...]

PowerPivot for Excel add-in is not coming up in Excel

After installing the PowerPivot for Excel add-in there are various things that you can to do attempt to debug the situation:

First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
Next ensure that you [...]

PowerPivot for Excel 2010 is now available as a download

For those who would looking for specific downloads of the PowerPivot for Excel 2010 RTM bits , here they are:

Important : If you install the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot. If you install the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot.

PowerPivot [...]

New “Single Server Install” page (covers RTM version)

Now that RTM has been released, I have started to update the installation pages in the “Server Installation” section. If you are interested, take a look at: http://powerpivotgeek.com/server-installation/single-server-install-rtm/  It has been updated for RTM w/ some new screen shots. You will see the only real difference is that all of the required hotfixes and other [...]

PowerPivot and Windows 7

Recently I had a conversation with one of our excellent beta testers and I want to make sure that everyone was clear about running PowerPivot on Windows 7.

Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint

Installing the right version of SharePoint

So you think that you have done everything right, but still SQL setup (in PowerPivot SharePoint integration mode) still reports “You don’t have a ‘Complete’ SharePoint installation.” How can this happen?

You might not have followed the installation guide. It tells you to first select “Farm” and then “Complete” on your first two screens after you [...]

Uninstalling PowerPivot for Excel

A trick for the client-side folks doing build-to-build reinstallations (or if you wish to clear all of the PowerPivot code from your client): besides uninstalling “Microsoft PowerPivot for Excel” (via control panel Add/Remove/Uninstall Programs, the exact wording varies depending on the OS you are running), you may also have to delete files in:

C:\Program Files\Microsoft Analysis [...]

How to start debugging a PowerPivot for SharePoint installation issue

A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running [...]