Error #REF! in IMPORTRANGE in GOOGLE Sheets. How to fix?

Question

Google Sheets

A strange error came out with the wording shown in the picture. Who knows how to get around and what to do to make the command work?

Answer 1

Apparently the data intersect, i.e. the top and/or left formula cannot output the entire array, because below and / or to the right something is already there.
You can bypass it like this:

={
IMPORTRANGE(...);
IMPORTRANGE(...);
IMPORTRANGE(...)
}

The data will be displayed in a column, only it is necessary that everyone has an equal number of columns

Answer 2

Incorrectly refer to the sheet, KMK. You "Доп данные!A2"must have "'Доп данные'!A2"(sheet name in single quotes).

Answer 3

Recently faced the same problem. In my case, the only error was that I was trying to link to an xlsx file on google drive. Through the file menu, I saved it as a Google spreadsheet, and there were no problems with further use of links to this spreadsheet