I am getting the same error as described here except not for the same reason. I am using the new Google Sheets, so I am supposed to be able to paste the entire source URL into the sheet, like so:

=ImportRange("https://docs.google.com/spreadsheets/d/1zRHatplJ6AVUSWr1HXoycUrvtK05dw4-ZqeEYN1xJ4Y/edit?usp=sharing", "B:B")

However, that results in the error:

The requested spreadsheet key, sheet title, or cell range was not found.

I am the author of both sheets, so I see no reason for the error to occur. Also, since I'm trying to get the data from the second column of the first sheet in the source, I shouldn't need to include the sheet name. Nonetheless, I have tried it both with and without the sheet name, and got the same results.

Anyone have any idea what I'm doing wrong?

Edit: Here is the source sheet, and here is the destination sheet (in particular, the "Data" sheet).

  • Tried all kinds of different scenarios but wasn't able to reproduce the error. This it possible for you to share the two doc with us? Or throw in a screenshot? – Jacob Jan Tuinstra Mar 10 '15 at 19:05
  • @JacobJanTuinstra I've added links to the sheets, which I have permitted access to for anyone with the link. – tlewis3348 Mar 10 '15 at 19:28
  • @JacobJanTuinstra Sorry, got distracted. – tlewis3348 Mar 10 '15 at 20:32
up vote 1 down vote accepted

Only after having requested that the documents were to be shared with us, was I able to determine what's going on.

The response sheet is new Google Sheet proof:
enter image description here

The sheet, in which you want to pull the data in, doesn't have this mark.

You are trying to import the data via the complete URL (new Sheets style) from within an old Google Spreadsheet. This is where Google says: No Can Do !!

If you use the key instead, it works just fine:

 =IMPORTRANGE("1zRHatplJ6AVUSWr1HXoycUrvtK05dw4-ZqeEYN1xJ4Y", "B:B")

See references for more information on this topic.

References

  • 1
    Ah! Brilliant! Thanks for the extra set of eyes. This was driving me insane! – tlewis3348 Mar 10 '15 at 20:00

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.