PowerPivotGeek?

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

PowerPivot and Windows 7

Recently I was making a pass through my old emails and I noticed that several folks have been asking me about PowerPivot and Windows 7. As you know – and I hope that everyone knows – PowerPivot is *NOT* supported on Windows 7. We have very specific prerequisite requirements – and running on a Windows [...]

Installation error: “System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances.”

Occasionally I’ve ran into this problem as part of a SharePoint installation. Typically this is with Excel Services – but since Excel Services is so central to the PowerPivot architecture, we run into this too. The ULS shows something like:

Medium             ExcelServiceBase.BeginProcessOperation: Caught an exception: System.TypeInitializationException: The type initializer for ‘Microsoft.Office.Excel.Server.CalculationServer.ExcelServerApp’ threw an exception. —> System.IO.FileLoadException: [...]

Cheat sheet: Pointer to the right installation instructions

1 — Is this a single machine farm? Will it be used for departmental use? Then go for “New Server”: http://msdn.microsoft.com/en-us/library/ee210708.aspx  This is NOT a standalone machine in SharePoint terms (PowerPivot does not support standalone SharePoint installations) — It is a full farm with all the capabilities of a farm, it is just that we [...]

Bug: cannot install PowerPivot if a SQL Server shared folder has been specified in a previous installation to other than the default folder

Clearly if you read my blog, you will see that as a development team we could have done a better job of testing all of the various installation combinations with SQL Server on ‘test servers’. Unfortunately, our limited test time was focused on production configurations; not on single demo machines. So as a result you [...]

A Peek Inside: Special steps for Excel Services-only app servers

It has been a while since I did one of the “A Peek Inside” postings and I thought “what the heck . . . do I have anything better to do while I am visiting with my in-laws during a vacation” . . . I couldn’t think of one so here goes.

PowerPivot has some special [...]

Cheat sheet: Re-installing the client add-in

“Help! My PowerPivot for Excel is totally messed up. How do I just reinstall everything?”

I’ve had to do this lots of times as we’ve gone through various beta builds. Here are the steps that I go through to totally clear out the client add-in:

Uninstall the PowerPivot for Excel add-in
Manually delete all the files under [...]

Updated: Links to the Single Server Installation Guide

Newly published this week is the final version of the PowerPivot for SharePoint – Single Server Installation Guide. I’ve updated the “Server Installation” pointers at the top of my blog to indicate the new pointers. If interested, visit here: http://powerpivotgeek.com/server-installation/single-server-install-rtm/

Enjoy!

Installing PowerPivot on a standalone server

Recently there have been several asks on the forums about getting more information for installing PowerPivot on a standalone server. Well . . . we have a video produced that addresses how to do this. Besides the installation itself, I also discuss how you go about adding the domain controller role to the server and [...]

If running on Windows Server, make sure you have ‘Desktop Experience’ feature turned on

Oh the joys of SharePoint again. I just responded to an internal posting where someone was raising the issue that “Path not found” errors were being reported when Excel Desktop tried to publish a workbook to SharePoint. Again, this isn’t PowerPivot directly, but it can be reported as a PowerPivot problem if the workbook contains [...]

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