Spread Designer

To turn off automatic formula calculation and updates

In the Spread Designer,

1. From the Book menu, choose Environment or press the Environment button ( ) on the Book toolbar.
2. On the General tab in the Sheet Environment Settings dialog box under Settings,
   • If you want to turn off automatic formula calculation, clear the Calculate Formulas check box.
   • If you want to turn off automatic formula updates, clear the Formula Sync check box.
3. Choose the OK or Apply button.