UPDATE

Purpose:

Updates each formula in a Worksheet.

Syntax:

UPDATE

Returns:

The entire Worksheet is re-evaluated just as if each formula were to be re-typed.

Example:

update

 

UPDATE sequences through each Window in the Worksheet and re-evaluates all formulas. Unlike REFRESH, each formula is re-evaluated just as if it were manually re-entered into the Window. UPDATE is useful for updating Worksheets from prior releases to the current release. This is particularly true if the old Worksheet contains functions that have been revised in the latest release.

Remarks:

Window formulas which have the direct series load form DATASET.VER.SERIES (e.g., RUN1.1.ANALOG1) are now re-evaluated with UPDATE. The LOADSERIES command also loads series (e.g., loadseries("RUN1.1.ANALOG1").

 

See REFRESH to re-evaluated each Window formula in proper dependency order using the low level compiled representation.

See Also:

CALC

LOADSERIES

REFRESH