[Solved] Preventing update

[robbyn]

I need to edit a complex inter connected spreadsheet. I would like to turn off all updating until I have finished the editing. Is it possible? The reason I ask is that every time I make a change I have to wait a long time to be able to do the next one.
(I am not referring to only stopping updating when the sheet is opened.)

[John_Ha]

It sounds like you shouldn't be using a spreadsheet if it is that complex. The average PC can do millions if not billions of calculations a second. For example, updating a 1.4 MB .ods file with 80,000 cells each needing calculating, needing about 1,000,000 calculations is almost instantaneous.

Switch off Data > Calculate > Autocalculate.

Use F9 to force a calculate.

Be very careful you don't forget ...

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.

[robbyn]

Thank you. Most of the problem comes from using live external data that is scraped into the spreadsheet.

[John_Ha]

Most of the problem comes from using live external data that is scraped into the spreadsheet.

Separate the tasks. Have a process to get the remote data into a file. Read from the file.