Hi everyone, I have a google sheet that i pull data into excel with using the "Get data from web" fuction and it works amazingly, however, it only pulls in the sheets that where present when i created the query? so heres what i do, i have google sheet to share link then i created this link which works (https://docs.google.com/spreadsheets/d/1G7uW1cFintOwlN7mGFvR0NfWZvY7KbPltWRSO2ge1KQ/export?format=xlsx) it has 4 sheet in the document, i set up the get data from web, and click select multile sheets and select all of then but when i add a sheet the conection does not add the sheet in, is there a setting or a way i can get it to bring in all sheets ? thanks Tony

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Can get data pull in every sheet from a link automaticly?

Thread starter tonywatsonhelp
Start date Feb 19, 2021

tonywatsonhelp

Well-known Member

Feb 19, 2021

Hi everyone,

I have a google sheet that i pull data into excel with using the "Get data from web" fuction and it works amazingly,
however, it only pulls in the sheets that where present when i created the query?

so heres what i do,
i have google sheet to share link then i created this link which works (https://docs.google.com/spreadsheet...FvR0NfWZvY7KbPltWRSO2ge1KQ/export?format=xlsx)
it has 4 sheet in the document,

i set up the get data from web, and click select multile sheets and select all of then
but when i add a sheet the conection does not add the sheet in,
is there a setting or a way i can get it to bring in all sheets ?
thanks
Tony