What you are seeing is a spreadsheet package's default behaviour.

Google Spreadsehets has an option under File > Spreadsheet Settings > Recalcualtion.

But unfortunately there does not need to be a "recalculate on user request only" option: instead all the available options include "on change". (This is different to Excel, for example, which does have a manual only option for worksheet calculation).

One option would be to to split your data into multiple sheets, so that the amount of data to be saved in each one is less.

What you are seeing is a spreadsheet package's default behaviour.

Google Spreadsehets has an option under File > Spreadsheet Settings > Recalcualtion.

But unfortunately there does not seem to be a "recalculate on user request only" option: instead all the available options include "on change". (This is different to Excel, for example, which does have a manual only option for worksheet calculation).

One option would be to to split your data into multiple sheets, so that the amount of data to be saved in each one is less.