Is it possible to have datasources from multiple Sharepoint Sites?

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?