If I open a sheet and click on a cell or move the cursor before it finishes
calculating, it hangs and goes into autorecover mode.

Is there are way to turn off autocalc for ever.

How about some other suggestion to keep it from locking up.