Need to create a linked table to an Excel spreadsheet that has an internet address. I receive the error "Only XML files can be imported from an internet address.

https://social.technet.microsoft.com/Forums/office/en-US/2cc4905e-a8f7-437e-921a-88843354bce5/need-to-create-a-linked-table-to-an-excel-spreadsheet-that-has-an-internet-address-i-receive-the?forum=sharepointgeneral The post in the link above seems to have solved this problem for a lot of people, except me. I'm not sure what I'm doing wrong. In the post Chelsea says to right click the excel file and select properties, then to copy the URL under location and then add the file's name at the end. It appears in the screenshots that she's meaning to right click the folder that the specific excel file is in, copy that address and then add the name of the specific file from the folder who's URL you just copied. Am i reading that correctly? It doesn't seem to matter which way I try, I still end up with the same error message from the beginning.