Troubleshooting PowerPivot on SharePoint

I recently had a battle with a SharePoint 2010 farm and PowerPivot. Customer reported "weird things are going on", and that was an understatement. This blog post is a transcript of the errors and what I did to resolve them. I hope this helps someone else in the future. First off, I checked the server's... Continue Reading →

Advertisements

More iPad support for SharePoint: Dashboards, PowerPivot, & Excel!

It's nice to see Microsoft playing nice with others. The cumulative update 2011-12 (CU Dec 2011, or Feb 2012) includes improvements around the iPad. Specifically, users can now access dashboards, Excel services, and PowerPivot services via their iPad! For complete details, check out http://technet.microsoft.com/en-us/library/hh697482.aspx. There's a great video on that page that walks through how well... Continue Reading →

PowerPivot Walkthrough Using SharePoint Lists

Before we can just walk through using PowerPivot and SharePoint, we need to make sure things are in order. Some prerequisites PowerPivot has been installed and properly configured on your farm. Download PowerPivot for Excel 2010, SQL Server 2008 R2 version (SQL 2012 version WILL NOT WORK!) for free at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609. I am using the Northwind sample... Continue Reading →

Blog at WordPress.com.

Up ↑