refresh_pivot
Update a pivot table's rows and columns to match its source data, ensuring all groups appear before reading or reporting. Safe to run anytime—no changes means no effect.
Instructions
Bring a pivot's rows and columns back in line with its source.
Its NUMBERS were never stale — they are live formulas. Only the set of rows and columns falls behind, because no formula can add a row. That is exactly why this matters: a stale pivot shows correct numbers with whole groups missing, and totals taken from it are short with nothing to say so.
Call it before reading or reporting a pivot that describe_block flagged. Safe and cheap to call when nothing has changed — it reports that it did nothing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Ref name of the pivot block. |