Difference between revisions of "Refresh Grids and Formulae"
m (moved Refresh Grids/Formulae to Refresh Grids and Formulae) |
|||
| Line 15: | Line 15: | ||
* 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|200px|centre]] | [[Image:RG4.png|200px|centre]] | ||
| − | |||
'''Formulae''' can be refreshed by: | '''Formulae''' can be refreshed by: | ||
* using the Refresh Formulae on the Refresh Menu | * using the Refresh Formulae on the Refresh Menu | ||
| − | |||
[[Image:RG5.png|50px|centre]] | [[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) | ||
| − | |||
'''Slicers''' can be refreshed by using the Refresh Slicer on the Refresh menu | '''Slicers''' can be refreshed by using the Refresh Slicer on the Refresh menu | ||
| − | |||
| − | |||
[[Image:RG6.png|50px|centre]] | [[Image:RG6.png|50px|centre]] | ||
Revision as of 14:59, 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
