I've got two Google Spreadsheets. Spreadsheet B fetches data from Spreadsheet A using IMPORTRANGE:

=IMPORTRANGE("url", "tab!A1:JB19")

What I want to achieve is to be able to write over fetched data inside Spreadsheet B - for example edit chosen cells. Unfortunately, when I try to change even one cell, the whole data from IMPORTRANGE disappears.

Is there any way to do edit data fetched from another Google Sheet?

  • Welcome. Have you tried Copy - Paste as value only? – Rubén Oct 14 '19 at 16:53
  • Hi. The spreadsheet that is copied is being modified by many people pretty much all the time and I would like my new spreadsheet to receive all of the updates as soon as possible. – nieosw Oct 15 '19 at 9:46