Question: 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](https://i.stack.imgur.com/mV32J.png)](https://i.stack.imgur.com/mV32J.png)

Can someone help me?

Answer: 
you can open this website for solution your problem : [link](https://blog.coupler.io/importrange-not-working/)
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](https://i.stack.imgur.com/9sUw5.png)