View source for XL3RefreshConnections

Refreshes objects connected to a connection - new in Version 9.

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==

{{Code|XL3RefreshConnections( RunRefresh, ConnectionID1, [ConnectionID2],…, [ConnectionID16] )}}

==Parameters==
{| class="wikitable"
! Parameter
! Description
|-
| {{Code|RunRefresh}}
| Should 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.
|-
| {{Code|ConnectionID1,…,ConnectionID16}}
| Number. Connection to refresh.
|}

==Example==
This example assumes you are using cell $A$1 to hold the RunRefresh variable. We will refresh just Connection 1.

First, create the XL3RefreshConnections, as follows:
<pre>
=XL3RefreshConnections($A$1, 1)
</pre>

Next set up the link to fire the refresh, as follows:
<pre>
=XL3Link(XL3Address($A$1),"Refresh All",,XL3Address($A$1),TRUE)
</pre>

Now clicking the hyperlink will refresh all grids/small multiples/etc connected to connection 1 in the workbook.

==See Also==
* [[Formula Reference]]
* [[XL3RefreshObjects]]
* [[XL3RefreshObjectsNamed]]

[[Category:Formulae]]
[[Category:Report Management Formulae]]
[[Category:Report Management]]