External sources
Contents
[hide]Overview
New in 2405.1 - allows for data to be pulled from an external set of workbooks. These can be accessed from a number of different sources.
The values and named ranges (if supported) would be pulled from the specified worksheets, overwriting any data in the sheet with the same name. The named ranges could be used to create Pivot views or VLookups to present the data on another worksheet.
The data would be updated whenever the workbook is opened, in Excel and on the Web (including scheduling, Send To etc.)
Setup
Enter the path for the workbook, this could be a UNC to access a network share i.e. //server//share//folder/file.xlsx
Limitations
If opening in Excel then the location would need to be accessible by the user from their desktop machine.
If opening in the Web then the location would need to be accessible from the web server.
Azure blob storage
Provide the connection string and blob container name to access the files on the store, the information is stored with the workbook to ensure the data can be re-retrieved on open.
Limitations
If opening on the Web the web server would require internet access.
Webpage
Enter the web page url and the name of the worksheet to pull the data into. Only simple web page structure will be bought into the worksheet and required no authentication.
