Introduction to the DeltaV Excel Add-in

Stop workbook updates

  1. Select the File tab.
  2. Select Options and then click Formulas.
  3. In the Calculation options section, under Workbook Calculation, select Manual.
  4. Make sure the Recalculate workbook before saving option is not selected.
  5. Click OK.
    Note

    This procedure does not disconnect the data server; rather, it simply prevents the read functions from reading at the update interval you established with DVUpdateInterval.

    Tip

    This procedure stops updates for existing cells. If you create a new read function in manual mode, it will read process data once when you click Finish. The existing cells will not be updated.

  6. To retrieve data while in manual calculation mode, press F9.
Related information