I have successfully pointed an excel reader to a sharepoint file. It depends on the permissions.

I am the file owner so have permission to edit it. Does it require more than that?

On the excel reader, there should be a parameter called network authentication. In my setup, I used NTLM authentication.

Hi @sam_tw,

Is the version of SharePoint, where the Excel file is located, Online or Server? If Online, then as far as I know, you can't connect using the Excel Reader as it requires SAML Authentication. If however it's SharePoint Server, then as @jdh has said, you should be okay. Select File From Web and Specify the URL to the SharePoint Site:

You should then have the option, as @jdh says, to Use Network Authentication and select NTLM as the Authentication Method.

Hope this helps.

Simon

Ah it is the online version of Sharepoint which explains why it isn't working, but the Sharepoint list reader using SAML does. Thanks

When I go "Select File from Web" -> "Specify URL": the link required seems to start with http: but my link start with https; and then if I put my link (the one with https) there, the transformer doesn't read anything. I did try to change to http but it doesn't work either.

what does this indicate?