Contents
How do I create a connection in Excel?
On the Data tab, click Connections. On the Workbook Connections dialog box, select the connection that you just opened, and then click Properties. On the Connection Properties dialog box, on the Definition tab, select the Always use connection file check box, and then click OK.
How do I remove all external data connections in Excel?
Delete an external data range On the formula bar, click the arrow next to the Name Box, and then click the name of the external data range that you want to delete. If the external data range is an Excel table, press CTRL+A to select the entire table. To delete the external data range, press DELETE.
Why does SharePoint say external data refresh failed?
Excel file “refresh all” works fine if I download it out from SharePoint. However, if I try use file in excel services it gives me an error message: “External Data Refresh Failed”. I have tried various fixes, what I could find in google but no luck.
For more information, see Configure Excel Services data refresh by using the unattended service account in SharePoint Server 2013. You can specify a Secure Store target application in a workbook. (This is known as an embedded connection.)
How to configure Excel Services data refresh?
You can use an unattended service account. For more information, see Configure Excel Services data refresh by using the unattended service account in SharePoint Server 2013. You can specify a Secure Store target application in a workbook.
What to do if SharePoint says services is not running?
First, inspect the SharePoint ULS trace log for errors. Filter on the Excel Services category. If the error pf_check_error 0x80070542 shows then you need to check the Claims to Windows Token Service in SharePoint. It must be started and it must also be running as Local System.