You could assemble the data somewhere else, for example in a database, and then write it into the target spreadsheet when you're finished, or you could override it every time you assemble new data.