To trigger a report to refresh, use the
SW_REFRESH(<address of top-left cell of report>)
function. This function is similar to clicking on the Refresh button of a report to refresh it.
Examples:
- Refresh a report in cell
A1
:SW_REFRESH("A1")
- Use the
CELL
function to convert a cell reference into an address:SW_REFRESH(CELL("address", A1))
- Refresh a report in cell
A1
in sheetMySheet
:SW_REFRESH(CELL("address", MySheet!A1))
- Refresh a report when the checkbox in cell
A9
is checked:IF(A9, SW_REFRESH(CELL("address", A1)))