Difference between revisions of "Refresh Grids and Formulae"
Line 31: | Line 31: | ||
'''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|left]] | [[Image:RG6.png|50px|left]] |
Revision as of 14:30, 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