Archive for February, 2010

Uninstalling PowerPivot for Excel

By powerpivotgeek (, on February 24th, 2010

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:

Read more…

PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience

For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed.  But if you are using a Windows Server  OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager.

Why you ask?

Read more…

When is null not a null?

By powerpivotgeek (, on February 15th, 2010

Recently there have been some discussions on the forums and in other areas concerning how PowerPivot handles nulls. As this has changed between CTP3 (back in November) and the upcoming RTM of the product, I thought that it would be a good posting. Here is the situation: suppose you have a simple calculated measure:

Read more…

Cannot add the specified assembly to the global assembly cache

By Lee Graber (, on February 12th, 2010

This is part of my continuing series on debugging SharePoint and PowerPivot. In this case, I do not expect any PowerPivot users to ever encounter this error in the context of PowerPivot. However, the general SharePoint developer who is in the early stages of building and testing his custom solutions might hit this and since so many people on our team have been confused by it, I thought I would throw out some help for other developers. This error is hit when trying to deploy a SharePoint solution package to the farm. It could be an ApplicationServer solution or a WebFrontEnd solution, the important part is that it has an assembly marked to be deployed to the GAC:

Read more…

The data connection uses Windows Authentication and user credentials could not be delegated

By Lee Graber (, on February 8th, 2010

This is one of the two main errors that users could see from Excel Services when using PowerPivot. This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of understanding of what Excel Services is doing is required. For this, I recommend reading an earlier post on this blog by Dave … In general, this is an add-on to Dave’s post which is a quick summary of how to debug this error.

Read more…

Dashboard Bubble Chart Shows a Red X (fails to load)

By Lee Graber (, on February 8th, 2010

If there is any error trying to load the bubble chart data for the dashboard, instead of getting a page load failure, the bubble chart simply displays a red X. Whenever you get a red X in the bubble chart there will be an associated log entry in the ULS log on the machine running the Central Admin site. It will look something like this:

Read more…

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook

By Lee Graber (, on February 7th, 2010

This error is another in a series of common errors that users can hit during seemingly normal scenarios that might be a little bit difficult to interpret at first. We actually did work to try and make the error descriptive, but to the new user, it may still be cryptic. This error occurs when you chose the “Manage PowerPivot Data Refresh” option of an xlsx file which does not contain any embedded PowerPivot data.

Read more…

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved