Difference between revisions of "Refresh Grids and Formulae"
| Line 25: | Line 25: | ||
| − | [[Image:RG5.png|50px| | + | [[Image:RG5.png|50px|centre]] |
* or by using standard Excel keys (F9 / Ctrl/Alt/Shift/F9 etc) | * or by using standard Excel keys (F9 / Ctrl/Alt/Shift/F9 etc) | ||
| Line 34: | Line 34: | ||
| − | [[Image:RG6.png|50px| | + | [[Image:RG6.png|50px|centre]] |
Revision as of 14:31, 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
