Archive for June, 2010

PowerPivot, you are so insensitive! (case that is)

June 18, 2010 by dennyglee

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive.

For example, if you import the table below:

Continue reading: PowerPivot, you are so insensitive! (case that is)


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

By powerpivotgeek (, on June 17th, 2010

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:

Click through to continue reading.

Modifying the SharePoint v4.master page for the PowerPivot Gallery

By powerpivotgeek (, on June 17th, 2010

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:

Click through to continue reading

Installing and Uninstalling PowerPivot does WHAT?

PowerPivotGeek has posted some mightly good stuff concerning the installation and uninstallation of PowerPivot. The quick summaries are:

Compliments of PowerPivotGeek!

Changing service accounts and handling password resets

By powerpivotgeek (, on June 14th, 2010

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.

Please click to continue reading.

Side Note: As well, there is an in depth discussion on Changing Passwords in Chapter 9 of Professional Microsoft PowerPivot for Excel and SharePoint.

Why is allocation always selecting the same machine?

By powerpivotgeek (, on June 14th, 2010

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
  • Health-Based

Please click to continue reading.

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


Copyright © 2010 Denny G Lee - All Rights Reserved