-4

I want to write in the row under the function IMPORTRANGE but when I do that the function stop working bc it cant increase. Can someone know how to solve that pls? here is my google sheet :

exemple: When i want to write in the row 15 column A,B,C or D the function stop working and I have a REF ERROR but I want to be able to write

Azuka
  • 19
  • 4

1 Answers1

0

The IMPORTRANGE() function occupies a range based on the data that queries. If you add some content within the datarange that importrange returns, the latter will break because it can't expand.

You can either restrict the range that importrange occupies:

=IMPORTRANGE("SprdID";"All Months!$A$1:$D14")

or add content starting from column E. You can also put the importrange function in bottom rows and use the top rows for manually entered data.

Since the raw data could potentially increase in the future, I would advice you to have a dedicated sheet to accommodate the importrange function and all of the other calculations/formulas to be stored in a different sheet.

References:

https://support.google.com/docs/thread/26662291?hl=en

Marios
  • 26,333
  • 8
  • 32
  • 52
  • I cant bc the data is going to grow so I must put " All Months!$A$1:$D" and I cant add content in the column E. My boss want to under the function IMPORTRANGE – Azuka Aug 19 '20 at 21:40
  • why don't you then put the importrange at lower rows? put the formula let's say in row 50, and do your calculations before that. – Marios Aug 19 '20 at 21:41