This question came up and since I am not a user of Sharepoint, I thought I’d see what the community knows.
In app that is MOSTLY connected to a database, it has one table currently connected to an Excel workbook in Sharepoint. An attempt was made to connect a second Excel workbook from a second Sharepoint site.
Errors were presented.
Oddly enough the error complained that the table, connected to the original Sharepoint site, could not be found.
Cna an app only use a single Sharepoint site as a datasource?