Hi,
We have a large amount of work being done collaboratively in Google Sheets. I want to link the data into a spreadsheet I am working in.
When I run the "Get Data from Web" query and enter the web address of the published document all I get is
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have managed in the past to have the spreadsheet query set so I can refresh via "Refresh All" but I can't remember how....Anyone any ideas???
Thanks
We have a large amount of work being done collaboratively in Google Sheets. I want to link the data into a spreadsheet I am working in.
When I run the "Get Data from Web" query and enter the web address of the published document all I get is
Kind | Name | Text |
Element | HTML |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have managed in the past to have the spreadsheet query set so I can refresh via "Refresh All" but I can't remember how....Anyone any ideas???
Thanks