Difference between revisions of "Refresh Grids and Formulae"

Line 32: Line 32:
  
 
[[Image:RG6.png|50px|centre]]
 
[[Image:RG6.png|50px|centre]]
 +
 +
== See Also ==
 +
* [[Grid Properties]]
 +
 +
[[Category:Grid Reporting]]

Revision as of 16:15, 17 June 2015

Grid Properties determine whether or not a grid will be automatically refreshed when the workbook is opened

RG1.png

All Grids can be refreshed at any time by using the Refresh All option under Grids & Tables on the Refresh Menu:

RG2.png


Individual Grids can be refreshed by:

  • selecting the required Grid from the list under Grids & Tables
RG3.png
  • or by using the right click XLCubed Menu -> Refresh Grid option
RG4.png
  • or pressing Ctrl + Shift + R while the active cell is in the grid


Formulae can be refreshed by:

  • using the Refresh Formulae on the Refresh Menu
RG5.png
  • or by using standard Excel keys (F9 / Ctrl/Alt/Shift/F9 etc)

Slicers can be refreshed by using the Refresh Slicer on the Refresh menu

RG6.png

See Also