I'm using an excel workbook with pivot in it. I'm using the Excess Webpart to display it. As I click on the Refresh all data connection.
It throws an error. The screen shot is attached.
I have configured the secure store service and Excel service application. Any Suggestions ??
I have installed SP2010 + SQL Server 2008R2 in server. I have an excel sheet which contains the pivot(the data comes from another SQL server).
I want to show that excel file in Sharepoint. I am using the Excel Web Access Webpart to show it, but on clicking the Refresh All Data connections, it throws an error. Firstly it was gving an error of Delegation. When i configured the Secure Store Service for Excel services, then the error changes to unable to refresh the Data Connection ,contact your system administrator.
Note: I tried to deploy powerpivot solution in SP 2010, but that solution was not found in the Farm Solution().
I 'm installing the Powerpivot(SQL Server) in existing setup.So please can you tell me how to proceed with the above mentioned scenario once when the installation of Powerpivot is complete ?
Can any one suggest anything related to it?
Thanks in Advance.