Archive for the 'Installation' Category

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

By powerpivotgeek (, on July 12th, 2010

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 PowerPivot data.

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


Using a SharePoint list as a data source

By powerpivotgeek (, on July 12th, 2010

So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality into the demo. Trying to be cool and ‘wow’ them, I decide to use a SharePoint list as a data source. I want to show the data mashup capabilities of PowerPivot so I have the bulk of my demo come from the Contoso sample database (the three product catalog tables) and the 4 million row Sales Fact table.

I create my SP list by extracting the 11 distinct manufacturers – and I assign them to a ‘shipper’ that I made up.

Continue reading: Using a SharePoint list as a data source

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.

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!

Delegation, Claims, Active Directory….Again?! Frak!

May 23, 2010 by dennyglee | Edit

 As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment.  In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated.

Giving remote users rights to log on to your domain controller

By powerpivotgeek (, on April 7th, 2010

For all of you that are running a combined all-in-1 system, i.e. domain controller, SharePoint and all of PowerPivot (desktop + server), you will notice that if you are trying to debug with non-administrator accounts that you can no longer remote desktop on to your machine. This is because by default only administrators are allowed to remote desktop onto a domain controller. To allow all Remote Desktop users that right:

  1. Click on Start and type “gpedit.msc” into the Start Search box
  2. Navigate to “Computer Configuration – Windows Settings – Security Settings – Local Policies – User rights Assignment”
  3. Click on “Allow log on through Terminal Services”
  4. You will notice that only Administrators are listed. Add “Remote Desktop Users”

Continue reading: Giving remote users rights to log on to your domain controller

64-bit verses 32-bit . . . What’s right for you?

By powerpivotgeek (, on March 25th, 2010

Recently we been hit with a rash of inquiries around whether folks should install the 32-bit version of the PowerPivot client, or go with the larger capacity 64-bit version. Office 2010 is the first version of Office to offer a native 64-bit option. In previous releases, you had to install the 32-bit version to run under WOW (Windows-On-Windows) mode. WOW emulates a 32-bit environment under the 64-bit OS. That is cool and all, but you were still limited by the 32-bit address space (2GB of memory). Now with Office 2010 64-bit the memory use is virtually unlimited for a client application.

So where to begin . . . Being a geek, let’s start off with a technical topic. When you are running in a 64-bit process, then you can only use dlls and other executables that are build as native 64-bit applications. Therefore whatever our choice, 32-bit or 64-bit, the ‘bit-ness’ of our approach has to hold for the entire process. For example, if we pick 64-bit, then we need the 64-bit version of Excel 2010, we need the 64-bit versions of any add-ins, such as PowerPivot for Excel, and we need 64-bit versions of any OLE DB providers or ODBC drivers (using the 64-bit version of the OLE DB Provider for ODBC here). So let’s keep that in mind.

Ok, here we go:

Read more…

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


Copyright © 2010 Denny G Lee - All Rights Reserved