Refreshes objects on a sheet based on type. This allows you to refresh objects on demand.

This function is for use with the XL3Link function, which can be used to switch the refresh on.

Syntax

XL3RefreshSheetObjects( [RunRefresh], [SheetName], [RefreshGrids], [RefreshTables], [RefreshSlicers], [RefreshSmallMultiples], [RefreshTreemaps] )

Parameters

ParameterDescription
RunRefreshShould the refresh fire. This should be a reference to another cell that contains TRUE or FALSE. Once the refresh fires that cell will be reset to FALSE. Use XL3Link to set the cell to true, causing a refresh.
SheetNameText. Sheet to refresh objects on.
RefreshGridsTRUE or FALSE. Refresh all grids.
RefreshTablesTRUE or FALSE. Refresh all tables.
RefreshSlicersTRUE or FALSE. Refresh all slicers.
RefreshSmallMultiplesTRUE or FALSE. Refresh all SmallMultiples.
RefreshTreemapsTRUE or FALSE. Refresh all treemaps.

You may also call the formula with just the RunRefresh and SheetName parameter to refresh all types.

Example

This example assumes you are using cell $A$1 to hold the RunRefresh variable. Refresh just the grids.

First, create the XL3RefreshSheetObjects:

=XL3RefreshSheetObjects($A$1, "Sheet1", True)

Next, set up the link to fire the refresh:

=XL3Link(XL3Address($A$1),"Refresh All",,XL3Address($A$1),TRUE)

Now, clicking the hyperlink will refresh all grids in the workbook.