获取错误“外部数据刷新失败”同时在excel文件中刷新excel odata查询，上传到sharepoint上 [英] Getting error "External data refresh failed" while refreshing excel odata queries in excel file uploaded on sharepoint online

问题描述

我已经在excel中创建了2个odata查询，它从2个共享点列表中提取数据。然后我附加了2个查询，将两个列表中的数据附加到一个。现在我有三个查询，查询1从列表1，查询2列表2和查询追加附加数据。我去连接设置，并检查该选项来刷新我的查询每次打开Excel文件，以便我有最新的数据从我的列表。
查询属性屏幕截图。
我保存的文件和uplaoded在sharepoint库。现在每当我在excel中从sharepoint中打开文件时，我得到一个错误外部数据刷新失败。错误讯息。
如果我按确定，数据不会刷新。

奇怪的是，如果我下载excel文件并在本地打开并刷新数据，这个问题不会出现。

解决方案

您需要在Secure Store中创建连接，并将凭据绑定到Excel电子表格以后使用。 p>

在Secure Store中提供用户帐户和密码后，您将需要返回到Excel电子表格，并将认证设置更改为与Secure Store，在应用程序ID中输入。

I have created 2 odata queries in excel which fetch data from 2 sharepoint lists. Then I appended the 2 queries to append the data from both list into one. Now i have three queries, Query 1 fro list 1, Query 2 for list 2, and Query append for appended data. I went to connection settings and checked the option to refresh my queries every time the excel file is opened so that I have latest data from my lists. Query Properties screenshot. I saved the file and uplaoded on sharepoint library. Now whenever i open the file from sharepoint in excel online I get an error "External data refresh failed".error message. The data doesnt get refreshed if i press ok.

Strangely this problem does not comes if I download the excel file and open it locally and refresh the data.

解决方案

You need to create a connection in the Secure Store and tie the credentials to later be used by your Excel spreadsheet.

Once you supply the user account and password in the Secure Store, you will need to get back to your Excel spreadsheet and change the authentication settings to match the one from the Secure Store, enter it on the Application ID.

这篇关于获取错误“外部数据刷新失败”同时在excel文件中刷新excel odata查询，上传到sharepoint上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！