Friday, October 28, 2011

PowerPivot Known Issues – SharePoint 2010

Below are some known Issues while working with PowerPivot and here is master key for below two solution :) 1) This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator.

Resolution: we need to add ‘SharePoint’ into excel services trusted file location.

2) Getting ‘An unexpected error has occurred.” Error while clicking ‘Manage Data Refresh’ icon into any of the stored workbook into PowerPivot gallery.

Resolution: we need to configure the unattended PowerPivot data refresh account for above to work properly.

I will also try to update this article if I find any more known issues with PowerPivot.

Good Luck.

No comments:

Post a Comment