CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
user15423370
user15423370

Reputation:

Why is Google Sheets IMPORTRANGE not working?

I tried to use this formula:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11GoENoRd_niJjJUa-tBxDKuORVzxPLGPMl4HdzbSUPo/edit#gid=1393359549", "Выкупы!A1:A1")

But I got this error:

error_img

Can someone help me?

Upvotes: 0

Views: 3316

Answers (2)

Rakesh
Rakesh

Reputation: 1

I found one solution after trying for days. its simple like this. Go to share the portion of the google sheets file which will be imported into or is not being properly imported. There you would remove the share links to existing emails and share to the public option to restricted and then redo the share.(This is almost like resetting the share option). Doing this my problem went away PUBLIC OPTION TO SHARE

Upvotes: 0

ryandi pratama purba
ryandi pratama purba

Reputation: 434

you can open this website for solution your problem : link

Upvotes: 2

Related Questions