Connecting to an Excel file in a SharePoint library

[Anonymous]

Hello,

We are trying to connect to one or more Excel files stored in a library on a SharePoint site. First is this I a web file as this has a URL or a direct Excel connection.

I note that that there is a connection to Excel, though this asks for a drive. I have mapped the SharePoint site to a drive, but I suspect some of the problems I mention below apply to both methods.

Connecting as a web file, is the URL the full URL including the file name itself, with Name field just to identify this subsequently in Qlik? Or do I separate the file name from the URL in the respective fields? Furthermore, do I include the SharePoint "forms" part of the URL?

I have experimented with both the Excel connection and the web file connection, and have had no success. Can anyone help please?

Thank you.