Live when you want it, frozen when you don't

Every =VERVE() cell looks up again when its inputs change, and repeat lookups within five minutes are free. Anything that shouldn't move, fill as plain values. Nothing runs on a timer or in the background — an idle sheet never spends a credit.

  • Live formulas
  • Values fill
  • Sheets & Excel
When a cell runs
  • Enter or editRuns
  • Input changesRuns
  • Ctrl+Alt+F9 (Excel)Runs
  • Clock timeNever
How refresh works

Live cells, on your terms

Formulas look up again when you change something. Repeats are free for five minutes, and you pay only for new lookups.

Live formulas

A =VERVE() cell looks up again when you enter or edit it, or when a cell it points at changes. In Excel, Ctrl+Alt+F9 re-runs every formula at once.

  • inputs change → new answer

Repeats are free for five minutes

An identical lookup — same source, same inputs — reuses the first answer for five minutes, whichever cell asks. Three columns over the same input cost about the same as one.

  • no double-charging

Values fill

Fill a selection from the sidebar as plain values: one batched request, written as static cells that never look up or charge again.

  • freeze once, keep forever

Nothing runs behind your back

No timer and no background job. Formulas run while the file is open and something asks them to, so an idle sheet never spends a credit.

  • idle = free
Set it up

Three steps to a sheet that stays right

Build the board, freeze what won't change, refresh the rest when you need to.

  1. 01

    Build the board with =VERVE

    Lay out the sheet and fill the live values with =VERVE("source", …) — rates, weather, prices, whatever you track.

  2. 02

    Decide what stays live

    Numbers that should move — a rate, a price — stay formulas. Lookups that won't change — an email check, a VIN, an IP's country — become plain values with a Values fill.

  3. 03

    Get a fresh answer when you want one

    Change an input or edit the formula in Google Sheets; press Ctrl+Alt+F9 in Excel. Anything older than five minutes is fetched fresh.

Patterns

Live where it matters

Formulas for the numbers that move, values for everything else.

A board you re-run on demand

Keep the handful of numbers that move — weather, a price — as live formulas, and re-run them when you sit down to the sheet.

  • =VERVE("weatherforecast","London","tempC")

One rate, many rows

Fetch today's rate into one cell and multiply a whole column by it — one lookup, not one per row.

  • =VERVE("exchangerate","USD","EUR","exchangeRate")

Enrich once, then freeze

Fill a column of IPs, emails or VINs as values. The answers stay in the file and never spend another credit.

  • =VERVE("timezonelookup",A2:A9,"timezone")

Refresh questions, answered.

When cells run, what it costs, and how to freeze them.

Talk to the team →
Do cells refresh on a schedule?
No. Spreadsheets run custom functions like =VERVE() when you enter or edit them, when a cell they point at changes, and — in Excel — on a full recalculation (Ctrl+Alt+F9). Nothing runs on a timer, and nothing runs for a closed file.
Does Google Sheets' recalculation setting help?
No. File ▸ Settings ▸ Calculation ("on change and every minute") re-runs built-in functions like NOW() and RAND(), not custom functions. To refresh a =VERVE() cell, change one of its inputs or edit the formula.
What does a refresh cost?
A run spends credits only when it needs a new lookup. The same lookup within five minutes reuses the first answer for free, failed lookups are not charged, and blank rows are skipped.
How do I stop a column from changing?
Fill it as Values from the sidebar, or copy the cells and paste values only. Plain values never look up again and never spend another credit.
Does it work the same in Excel?
The same rules apply in both: formulas run when their inputs change, repeats are free for five minutes, and Values fill freezes answers. Excel adds Ctrl+Alt+F9 to re-run every formula at once.

Live data in every cell. Add the extension, type one function, freeze what you want to keep.

Bigger workbooks?

Shared team keys, volume pricing, and priority support for data-heavy teams.

See pricing