Pull data from external sources

You can pull data from an external set of workbooks. You can access the workbooks from a number of different sources. 

Enter the path for the workbook. This could be a UNC to access a network share, for example: //server//share//folder/file.xlsx

If opening in Excel, the location must be accessible by the user from their computer.

If opening in the Web, the location must be accessible from the web server.

Give the connection string and blob container name to access the files on the store. The information is stored in the workbook. This ensures the data is retrieved when the workbook is opened.

If opening on the Web, the web server requires internet access.

Enter the web page URL and the name of the worksheet to pull the data into. Only simple web page structures that don't require authentication will be bought into the worksheet.