Query SharePoint from Excel

I am trying to establish a connection between an Excel file to an Excel file located on a SharePoint site in a folder. I select the "Get Data From Web option":

I enter the SharePoint site URL on which the file resides and am given the following error:

I have full permissions on the SharePoint site and have signed in when prompted. Has anyone seen this error before and / or developed a work-around?