从 sharepoint 2010 打开 Excel 数据透视表报告时出错
我使用 excel 2010 制作了一个数据透视表报告，该报告从 shareportint 2010 列表中检索数据，该报告在 excel 中运行良好，但是当我将其上传到文档库并将其放入 Web 部件中以从共享点查看时，它向我显示了此错误：
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]
什么我应该做什么来解决这个错误？
谢谢。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在使用外部数据连接时，您应该参考 MSDN 中的这篇文章 Excel 工作簿。在将工作簿发布到 SharePoint 之前，您必须确保该连接属于（管理员定义的）可信连接组。
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.
当尝试使用 SharePoint 2010 刷新 Excel Web 部件中的数据时，我遇到了类似的错误。
这是我的错误的屏幕截图：
SharePoint 错误
我的问题是我将 Excel 数据透视表的源直接设置为 SharePoint 列表。为了让它工作，我必须：
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: