Difference between revisions of "Refresh Grids and Formulae"
| Line 17: | Line 17: | ||
[[Image:RG4.png|200px|centre]] | [[Image:RG4.png|200px|centre]] | ||
| + | |||
| + | * or pressing Ctrl + Shift + R while the active cell is in the grid | ||
| + | |||
'''Formulae''' can be refreshed by: | '''Formulae''' can be refreshed by: | ||
Revision as of 15:29, 8 November 2013
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
- 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
- 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
