Sep 16 2019 12:07 PM
Hello!
I am trying to import data from a shared file via OneDrive (into another shared file via OneDrive).
I have tried two different options:
1) Using "GetData" from a file. This works if I am using my computer. The moment I use another computer with access to the same Drive, I have to re-link the data from the new computer to the same file. I even changed the names of the multiple computers to the same name, so they have the same "filepath". It is still not working (without re-linking the same workbook when on a different computer).
2) Using "GetData" from a excel link on OneDrive. I tried multiple links, the one that seems to work is "downloading" the file, and copying the download link. This only works until the file is changed and a new link makes the old download link obsolete.
Please advise on how I can use either methods to link the data, without having to update the links (or files) every time the sheet is opened from another computer, etc.
Thank you so much! I have spent countless hours trying to resolve this issue :(
Sep 17 2019 07:57 AM
Sep 17 2019 10:04 AM
Can you please relink? I am getting a: 504 Gateway Time-out message....
Thank you! @cuong
Sep 17 2019 12:12 PM - edited Sep 17 2019 12:12 PM
Sep 17 2019 12:20 PM
Sep 18 2019 03:52 PM
@Wyn Hopkins Thanks for the link! I went to the source file and clicked "copy link to clipboard", used the link to fetch the data from web, and received the following error:
"Unable to Connect
We encountered an error while trying to connect.
Details: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."
This is what my link looks like copied from the source file:
Thanks,
Emily
Sep 18 2019 11:43 PM
SolutionOct 07 2019 04:08 PM
SO sorry for the late response... was out of town. Your solution worked! Thank you so much! You saved my excel life :) @Wyn Hopkins
Sep 18 2019 11:43 PM
Solution