Hi, Im not sure if this was addressed upthread.
How do I have an excel sheet reference a cell on a Google Sheet, so that anytime the google sheet updates, the cell in MS Excel will update (or with a refresh).
Lets keep it simple and say we want to have cell A1 reference cell A1 on the google sheet.
So far I tried the following;
1) Published the Google sheet to web, and used that link in a "Get Data- From Web" query. It pulled the info in, but it did not refresh when I changed the data on the Google Sheet, and refreshed the Query.
2) I tried updating the share permissions to all who have the link, then downloaded the google file in Excel format, and used that download link for the "Get Data- From Web" query. This just got a long error about "Unable to Connect" , "Web.Contents failed to get contents from '
https://doc...."
Anyone have any experience with this and an easy fix?
Thanks