I'm trying to run a query (IMPORTRANGE) formula in a new Google sheet. The data I'm trying to load is from another sheet. The source sheet contains 6,000 rows and 12 columns. I tried:
The result is
#REF! and when I hover over the cell there is no additional information.
I also tried the IMPORTRANGE formula separately and it's loading the data correctly. I tried the exact same query in a new tab in the source sheet:
and the data was loaded successfully, however I need to run the query formula in a new Google sheet.