Calculating
The calculation buttons allow you to control exactly what cells are refreshed. They are used in conjunction with the calculation option (on/off). You can stop a calculation at any time except while the calculations are being accumulated from Excel.
Calculate Range, Sheet, Workbook or All
To calculate a range of cells simply:
- Highlight the range.
- Or select multiple ranges using the ctrl button (as normal in Excel).
- Or select a range and then select multiple Excel worksheets to calculate the same range on each sheet.
- Click the “Calculate Range” button.
Please note, do not use the range refresh option to recalculate the entire sheet i.e. by selecting all the cells on the sheet. This will take unnecessarily long. Rather use the sheet refresh option.
If you click range refresh while on a cell which is the input value for a GL Wand function, those functions will also calculate.
To calculate a sheet simply:
- Select the applicable sheet.
- Or select multiple sheets to calculate each of the selected sheets.
- Click the “Calculate Sheet” button.
To calculate a workbook simply:
- Select the applicable workbook.
- Click the “Calculate Workbook” button.
To calculate all open workbooks simply:
- Click the “Calculate All” button
Shortcut keys are available to start a calculation using the keyboard. Use Ctrl-Alt-R for a range calculation and similarly you can use “S”, “W” and “A” to trigger calculations on the sheet, workbook, and all open workbooks.
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.
Please note that this calculation option has nothing to do with Excel’s automatic and manual calculation. This calculation option controls only the calculation of the applicable GL Wand functions. All other calculations are controlled as normal by the Excel automatic and manual calculation option.
Calculation progress and stopping a calculation
When you perform a recalculation a window will appear to show the progress of the calculation and to allow to you stop the calculation. Once all the calculations have accumulated, you are able to continue working in Excel while the results are queried from the PeopleSoft server. You can also click the minimize button to show the minimal calculation window which will consume less space on the screen.
Showing the last calculated value
Normally when you open a GL Wand workbook, the values will calculate and will either show Pending or will begin querying the results from the Oracle server. An option in allows you to see the last calculated value that was saved with the workbook without needing to wait for the balances to resolve from PeopleSoft. To enable this option, see the Show last calculated value option under GL Wand User Options.