Grid Properties determine whether or not a grid will be automatically refreshed when the workbook is opened or when its driving cells or slicer(s) changes.

You can refresh the grids when:

  • Refresh grids on open.
  • Refresh when driving cells change.
  • Refresh when slicer/links change.
  • Display error on invalid members.
  • Warn when driving cells out of sync.

All grids can be refreshed at any time by selecting Refresh > Grids & Tables > Refresh All. From here you it's also possible to refresh individual grids and tables.

Another way to refresh grids is by selecting Refresh Grid from the Anaplan XL menu. You can also press Ctrl + Shift + R while the grid's active cell is selected.

You can refresh formulas by using the Refresh Formulas option from the Refresh ribbon menu or by using standard Excel keys (F9 / Ctrl/Alt/Shift/F9).

Use formulas to trigger a refresh

There are a few Anaplan XL formulas which can be used to refresh objects in a workbook:

    • XL3RefreshObjects
    • XL3RefreshSheetObjects
    • XL3RefreshObjectsNamed

Each needs a RunRefresh parameter, which is a reference to a cell with TRUE or FALSE to decide if the refresh should run. This cell can be populated by selecting an XL3Link. For example,

=XL3Link(, "Refresh", 1, XL3Address( A2 ), TRUE )

If a grid should be refreshed after a selection is made in an independent slicer, the slicer can be set to activate this XL3Link.