Skip to content
Refresh

Refresh

Refresh ([All], [Location], [ShowProgress], [TableName])
    All - {Boolean} | Optional. Set to True to refresh all reports, False to refresh selected.
    Location - {ListObject|Range|String} | Optional. Location in Excel of report to refresh. Can be a {Range} within a report, a {ListObject} containing the report, or a {String} matching the report's table name.
    ShowProgress - {Boolean} | Optional. Set to False to hide RadiusCore’s progress bar.
    TableName - {String} | DEPRECATED (v1.11.0). Do not use.

Refresh all or selected RadiusCore reports in the active workbook with the latest data from Xero.

VB
Sub radius_Sample()
    ' Error handling.
    On Error GoTo radius_ErrorHandling
    
    ' Refresh all RadiusCore reports in the active workbook.
    RadiusCore.Refresh All:=True
    
    ' Refresh selected table.
    RadiusCore.Refresh All:=False
    
    ' Refresh table called `RcTrialBalance` without showing the progress bar.
    RadiusCore.Refresh Location:="RcTrialBalance", ShowProgress:=False
    
    ' Refresh the first table on worksheet "MyReport"
    RadiusCore.Refresh Location:=Sheets.Item("MyReport").ListObjects.Item(1)
    
    Exit Sub
    
 radius_ErrorHandling:
    ' Implement per RadiusCore error handling example.
End Sub

© 2026 RadiusCore Documentation. All rights reserved.