Difference between revisions of "Refresh Grids and Formulae"
Line 12: | Line 12: | ||
* selecting the required Grid from the list under Grids & Tables | * selecting the required Grid from the list under Grids & Tables | ||
− | [[Image:RG3.png| | + | [[Image:RG3.png|200px|centre]] |
* or by using the right click XLCubed Menu -> Refresh Grid option | * or by using the right click XLCubed Menu -> Refresh Grid option | ||
− | [[Image:RG4.png| | + | [[Image:RG4.png|50px|centre]] |
Revision as of 14:27, 29 August 2012
Grid Properties determine whether or not a grid will be automatically refreshed when the workbook is opened
All Grids can be refreshed at any time by using the Refresh All option under Grids & Tables on the Refresh Menu:
Individual Grids can be refreshed by:
- selecting the required Grid from the list under Grids & Tables
- or by using the right click XLCubed Menu -> Refresh Grid option
Formulae can be refreshed by:
- using the Refresh Formulae on the Refresh Menu
- 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