We have a specific set of data that is being imported from another spreadsheet with the importrange function  =IMPORTRANGE(spreadsheetkey; sheetname!A8:F133).Now we want to change that data on one of the cell within this range , for example C64.When we do that we get the error:Error Array result was not expanded because it would overwrite data in C64How can we import the range and still be able to alter an arbitrary set of the imported data?
Allow data to be overwritten from importrange
google spreadsheets