Calculation on or off
You can use the calculation toggle button to control when requests for calculations are sent to the server. If you toggle GL Wand calculation "Off", calculation requests are not sent to the server which means you:
- Can manipulate a worksheet.
- Change cell values.
- Enter new functions.
- And perform any other task that would normally cause Excel to recalculate.
- And the applicable functions will only return the "Pending" status and will not actually calculate a result.
This is useful during report development. To calculate the results simply click one of the calculation buttons.
If you leave the GL Wand calculation option "On", the applicable functions will be recalculated whenever Excel initiates a calculation process e.g.
- When changing the contents of the cell.
- Or changing one of the function's input values.