'Synced' Google Sheet Not Overwriting Data

I’ve just done this:
=IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1K6ep9KgCgaXR3lMckIxB_sl8MSr1_dEzd3PWyEJqQ_8/edit?gid=0#gid=0”, “Outreach!A1:L657”)

And the L657 is the point I’ve written up to, but the data doesn’t sync. This is the error that comes up:

How can I be able to add data on the new sheet, and it syncs with the original?

You are having a value in cell A3 (321312 in the screenshot), just clear that and the data should sync.

Though, you should have your first row as static header, and import only from row 2 onwards for best syncing performance.


Ah ok, but isn’t there a way for me to write data in that sheet, AND it changes it in the original?

No, there isn’t. You can think of that as a read-only mirror of your original sheet.

1 Like