REFRESH

Refresh cells periodically and recalculate their formulas.

Parameter List

Syntax
REFRESH(range
[interval]
[unit]
[delay]
[unit]
)
range

Cell or range to be refreshed periodically. For example: A3 or B1:B6.

[optional] interval

The interval between cell or range refreshes. By default this is 1440 min (1 day). The minimum is 1 (min).

[optional] unit

The unit of time to use with the interval. Choose between:

  • "min" for minutes (default)
  • "h" for hours
  • "d" for days
  • "w" for weeks
  • "m" for months
Selected options:
days
hours
minutes
months
weeks
[optional] delay

The time until the first refresh. By default this is 1 (min). The minimum is 0 (min).

[optional] unit

The unit of time to use with the delay. Choose between:

  • "min" for minutes (default)
  • "h" for hours
  • "d" for days
  • "w" for weeks
  • "m" for months
Selected options:
days
hours
minutes
months
weeks
More details

The maximum interval for range and delay is six months.

Examples

REFRESH(A1) returns executes cell A1 in one minute and will refresh it every hour.