{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Evening l夕情丶 的问题《Getting error “External data refresh failed” while》','https://www.manongdao.com/q-1155024.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.