Archive for July, 2010

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

By powerpivotgeek (dwickert@microsoft.com), 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 

Advertisements

Using a SharePoint list as a data source

By powerpivotgeek (dwickert@microsoft.com), 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

Incoming emails to a PowerPivot Gallery

From time to time you run into something on SharePoint that is a known SharePoint ‘issue’, but you wouldn’t necessarily see PowerPivot being impacted. After all SharePoint is this huge juggernaut of a product and PowerPivot is just this one small little app in the corner. Well, here is one that I ran into today. We had a bug report that the incoming email setup for a PowerPivot Gallery was missing the ‘incoming emails’ link –> after some searching, I found this interesting posting:

Click through to continue reading.