Hi there,
The syntax of the function IMPORTRANGE is
IMPORTRANGE(“spreadsheet_url”, “range_string”)
This works very well, however, the spreadsheet I want to import data from, has multiple tabs (or sheets, don’t know what the official name is), and I cannot seem to import data from other tabs then the first one.
Example:
Let’s say spreadsheet_1 has two tabs, “A” and “B”
In spreadsheet_2 I want to IMPORTRANGE(“spreadsheet_1”,“B!A1”)
That doesn’t work.
When I type this into an empty cell, the content is removed upon enter, cell stays empty;
If the cell contains IMPORTRANGE(“spreadsheet_1”,“A!A1”) and I change the A!A1 into B!A1 it gets reverted to A!A1…
Hopefully I’m making myself a bit clear 
Can anybody point me in the right direction how to accomplish this?
Oh yes, forgot to mention I am trying this in the online onlyoffice, version 8.2.3.6
Thanks!
Hello @DeejaySane
First of all, please note that you are using outdated version of editors. I recommend updating the app in the first place.
To get the data from another sheet with IMPORTRANGE you have to specify the name of the sheet in single quotes like that:
=IMPORTRANGE("spreadsheet_1";"'B'!A1")
Here 'B' is the name of the sheet in referenced file.
Hope it helps.
hi @Constantine,
Thanks much for your reply, and the clarification for the syntax.
I couldn’t find this information in the docs.
But sadly, this gives me the same results as described…
So first I will ask my hosting company to update the software version.
And, I don’t know if this is due to the outdated version, but the IMPORTRANGE function doesn’t import a range as well
=IMPORTRANGE(“spreadsheet_1”,“‘B’!A1:A4”)
only imports the data in cell A1 …
I recommend updating Document Server. There were lots of improvements to IMPORTRANGE formula between 8.2 and 9.2.
Hi @Constantine
Thought so
Will ask the administrator to do this!
1 Like