I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection.
It throws an error.The scree shot is attached.
I have configured the secure store service and Excel service application. Any Suggestions ??
Thanks in Advance
Now the error showing is :
Thanks for the reply @1c1cle , @Mauro and @Stuart Pegg.
I have looked into your recomendations. Finally I found where the problem is :
The current senario is :
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 conections, 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 am 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 ?
Thanks In advance.