Skip to content
REFERENCE

U.RECALC

Summary

Presence of this method in any cell will cause workbook to be fully recalculated upon open provided the workbook is not in manual recalc mode and provided the 1st optional parameter is not negative. Will cause periodic recalc if period is provided

Syntax

=U.RECALC([recalc_interval], [ranges], [block])

Parameters

Parameter Required Description
[recalc_interval] No The interval in seconds on which the workbook will be recalculated. Min of 0.25 seconds and max of 3600 seconds (1 hour) is enforced. If negative then the workbook will not be fully recalculated when opened. By default the method does not cause periodic recalcs
[ranges] No The ranges to be forcibly recalculated at the specified interval. If set to TRUE then a full recalc is performed on the specified interval; if 2-columns wide and 2nd column is TRUE then Excel's calc dependency tree is cleared before the full recalc. By default a regular calculate is performed at the specified interval
[block] No If set to TRUE then method will not be calculated unless triggered by user interaction or calculated as a step in a script; If set to a number then will be throttled to not calculate more frequently than the specified number of seconds; make number negative to prevent auto recalc of blocked methods

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.RECALC(30)

=U.RECALC(G7,G10)

=U.RECALC(G9,G12)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.