PowerPivotGeek?

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

Installation error: Running the wrong version of SharePoint

(Well, maybe you are – maybe you aren’t . . . How can you check directly?)

In an earlier post (http://powerpivotgeek.com/2010/03/04/installing-the-right-version-of-sharepoint/) I spoke about the way that PowerPivot determines if you are on the right version of SharePoint. Cory Retherford reported some errors and after investigating it for a few days we found the solution.

Here is [...]

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 [...]

Modifying the SharePoint v4.master page for the PowerPivot Gallery

Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site.  If you interested in doing this, then the first thing to do is to make sure that you go to the right place:

Go to Site Settings -> Site Collection Features -> Make sure “SharePoint Server [...]

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 [...]

Changing service accounts and handling password resets

While this is technically a pure SharePoint posting, we have found it useful in our labs. We have password resets all of the time and this cheat sheet was developed to make it as painless as possible. I hope you find it as useful as we do.

Step 1: Start Services.msc

For each service using the machine [...]

Why is allocation always selecting the same machine?

If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:

Round-robin (the [...]

Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010

 

There are many reasons to go to TechEd North America 2010 in New Orleans this year.  After all, it is THE event for developers and IT Professionals.  And if you want to know more about PowerPivot, here’s yet another reason why you need to go.

There will be a raffle to win a signed copy of [...]