Refresh a report using a sheets function

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 sheet MySheet: SW_REFRESH(CELL("address", MySheet!A1))
Refresh a report when the checkbox in cell A9 is checked: IF(A9, SW_REFRESH(CELL("address", A1)))

Updated on: 04/27/2024