I have several pivot tables that present 5-7 columns of data extracted from a sheet that has about 30 column and 5000 rows.
That sheet in turn is updated everytime a line is entered in the orders sheet.
I'm finding unacceptable response time from my spread sheet, I think due to the cascade of calculations involved.
There is no way to effectively control the frequency of update in google sheets.