Difference between revisions of "Refresh Grids and Formulae"

(Created page with "Grid Properties determine whether or not a grid will be automatically refreshed when the workbook is opened 350px|centre All '''Grids''' can be refreshed at a...")
 
Line 5: Line 5:
 
All '''Grids''' can be refreshed at any time by using the Refresh All option under Grids & Tables on the Refresh Menu:
 
All '''Grids''' can be refreshed at any time by using the Refresh All option under Grids & Tables on the Refresh Menu:
  
[[Image:RG2.png|350px|centre]]
+
[[Image:RG2.png|200px|centre]]
  
  

Revision as of 14:26, 29 August 2012

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


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