Difference between revisions of "XL3RefreshObjectsNamed"
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Refreshes objects in the report based on their name. (New in | + | Refreshes objects in the report based on their name. (New in [[Version 7.1]]) |
This allows you to refresh objects on demand. Objects could be [[Grid|Grids]], [[Tables|Tables]], [[Slicers|Slicers]], [[Small Multiple Charts|SmallMultiples]] or [[Treemaps|Treemaps]]. | This allows you to refresh objects on demand. Objects could be [[Grid|Grids]], [[Tables|Tables]], [[Slicers|Slicers]], [[Small Multiple Charts|SmallMultiples]] or [[Treemaps|Treemaps]]. | ||
| Line 18: | Line 18: | ||
|- | |- | ||
| {{Code|[Name1],…, [NameN]}} | | {{Code|[Name1],…, [NameN]}} | ||
| − | | | + | | Names of the objects to refresh. |
|} | |} | ||
| Line 24: | Line 24: | ||
This example assumes you are using cell $A$1 to hold the RunRefresh variable. We will refresh a grid named "MyGrid". | This example assumes you are using cell $A$1 to hold the RunRefresh variable. We will refresh a grid named "MyGrid". | ||
| − | First, create the | + | First, create the XL3RefreshObjectsNamed, as follows: |
<pre> | <pre> | ||
| − | = | + | =XL3RefreshObjectsNamed($A$1, "MyGrid") |
</pre> | </pre> | ||
Next set up the link to fire the refresh, as follows: | Next set up the link to fire the refresh, as follows: | ||
<pre> | <pre> | ||
| − | =XL3Link(XL3Address($A$1),"Refresh | + | =XL3Link(XL3Address($A$1),"Refresh My Grid",,XL3Address($A$1),TRUE) |
</pre> | </pre> | ||
| Line 38: | Line 38: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3RefreshObjects]] | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
[[Category:Report Management Formulae]] | [[Category:Report Management Formulae]] | ||
[[Category:Report Management]] | [[Category:Report Management]] | ||
Latest revision as of 11:42, 7 September 2012
Refreshes objects in the report based on their name. (New in Version 7.1)
This allows you to refresh objects on demand. Objects could be Grids, Tables, Slicers, SmallMultiples or Treemaps.
This function is for use with the XL3Link function, which can be used to switch the refresh on.
Contents
[hide]Syntax
XL3RefreshObjectsNamed( [RunRefresh], [Name1],…, [Name29] )
Parameters
| Parameter | Description |
|---|---|
| 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. |
| [Name1],…, [NameN] | Names of the objects to refresh. |
Example
This example assumes you are using cell $A$1 to hold the RunRefresh variable. We will refresh a grid named "MyGrid".
First, create the XL3RefreshObjectsNamed, as follows:
=XL3RefreshObjectsNamed($A$1, "MyGrid")
Next set up the link to fire the refresh, as follows:
=XL3Link(XL3Address($A$1),"Refresh My Grid",,XL3Address($A$1),TRUE)
Now clicking the hyperlink will refresh the grid specified.
