I have a document where I am trying to mirror some data from one Google sheet to another. I have over 1000 rows in the first document; when I use the IMPORTRANGE formula it works fine as long as the last row in my formula is row 1000. Any row I add after that in the formula, I get a #REF error.


there is no row limit around the 1000 milestone (for rows). you get the #REF! error probably due to some other issue. see this example:

spreadsheet A has range A1:Z2000

spreadsheet B uses the formula:

=IMPORTRANGE("1RVKzTRTKF7mnkf1LUqIwqSdYooonHBaLYqytgdYQktg", "Sheet1!A1:ZZ3000")

note the range A1:ZZ3000

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.