195/10000
实时翻译
划译
Hello, I am using an editor for document processing, but I encountered a problem when using the 8.1 version of the IMPORTRANGE function. I cannot obtain the referenced data and keep prompting # N/A. After updating the link, it will be filled with 0, but in fact, there is data in another table referenced
Hello,
Please provide a screen recording that shows the exact steps to reproduce the issue.
I have converted the long link into a short link, which can directly enter the editing page when opened
We are currently analysing the issue, thank you for the provided info
Hello @hanqx
If you don’t mind I will join this thread as well.
Could you please run a test? Please try to set up IMPORTRANGE function in the cell directly (not via interface menu). For example, =IMPORTRANGE("link","Sheet1!A1:A6")
.
Please let us know if it resolves the situation.