Error while opening excel pivot table report from sharepoint 2010

0
votes

I made a pivot table report using excel 2010 that retrieving data from shareportint 2010 list, the report is working fine in excel but when I uploaded it to document library and put it in web part to view from share point it showing me this error :

Unable to refresh data for a data connection in the workbook. 
Try again or contact your system administrator. The following connections failed to refresh: 

owssvr[1]

what should I do to resolve this error?

Thanks.

2
excelsharepointsharepoint-2010sharepoint-designer
Did you inspect SharePoint's log files? – Ondrej Tucny
1) Was there any interesting information in the log file? 2) Yes. – Ondrej Tucny
One more side note: This type of question is a better fit for sharepoint.stackexchange.com. – Ondrej Tucny

2 Answers

1
votes

You should refer to this artice in MSDN when working with external data connections within an Excel workbook. Before publishing the workbook into SharePoint you must make sure the connection belongs among the set of (administrator-defined) trusted connections.

0
votes

I got a similar error when trying to refresh data in an Excel Web Part using SharePoint 2010.

Here is the screenshot of my error: SharePoint Error

My problem was that I was setting the source of the Excel Pivot tables directly to the SharePoint list. In order to get it to work I had to:

  1. Go to the SharePoint list to be used as a data source
  2. Select the "Export to Excel" button to obtain the .iqy file
  3. Save this file then open it in Excel which will open the list in Excel
  4. Any pivot tables created must then use this table as the source, not the connection that is found under the "existing connections" button in Excel