next up previous contents index
Next: 6.3.3 Enabling Constraint Checking Up: 6.3 Changing Calculation Options Previous: 6.3.1 Setting Recalculation Method

6.3.2 Controlling Automatic Recalculation

 

NExS lets you decide whether or not to recalculate the spreadsheet after you make changes that affect other cells or whenever the sheet is initially loaded. NExS automatically recalculates the spreadsheets in both cases if Recalculation Mode is set to Automatic.

However, this can be time-consuming for large spreadsheets, especially those with graphs that are automatically recalculated as well. If recalculation is occupying too much time, you can turn automatic recalculation off. NExS will only recalculate upon explicit request.

Disabling Automatic Recalculation

To turn automatic recalculation off:

  1. Select Recalc Options from the Options menu. NExS displays the Recalc Options dialog box as show in Figure 6.1.

  2. Move the pointer to the Recalc Mode option button. While holding down the left mouse button to display the options point to desired option and release.

  3. Apply your selection by clicking OK or Apply.

Manual Recalculation

 

To manually recalculate a spreadsheet, select Recalculate from the Tools menu or press [F9] on the keyboard.


next up previous contents index
Next: 6.3.3 Enabling Constraint Checking Up: 6.3 Changing Calculation Options Previous: 6.3.1 Setting Recalculation Method

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999