REFRESH

Purpose:

Causes the entire Worksheet to be re-calculated.

Syntax:

REFRESH(win, mode)

win

-

Optional, a window to update. Defaults to all windows in the worksheet.

mode

-

Optional. An integer, the update mode.

 

Remarks:

Refresh re-calculates each Window in the correct dependency order. Each formula is re-evaluated using the low level compiled representation.

 

See UPDATE to re-evaluate each Window formula exactly as if manually re-entering each formula.

See Also:

CALC

UPDATE