Contact Us
Index
Version 5.0
Version 5.1 Version 5.2 Version 5.3 Version 5.4 Version 5.5 Version 5.6 Version 20.1 Version 20.2 Version 20.3 Version 20.4 Version 21.2 Version 21.3 Version 21.4 Version 22.1 Version 22.2 Version 22.3 Version 22.4 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2
Contact Us
New Release Notification
Company Code Selection
User Profile
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key Errors
Snapshot
Shared Templates Drive
Drive Types
File Server
SAP Database
Dropbox
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
System Administrator Options
System Administrator Licence Key
System Administrator User Permissions
System Administrator User Options
System Administrator Server Information
System Administrator Delimiter Options
System Administrator Configuration Options
Expand and Explode Level
Discover FICO Object Values
Expand and Explode
Expand FICO Object Values
Explode FICO Object Values
Explode FICO Object Value Hierarchy
Expand FICO Object Value Hierarchy
List of Values – Create
Previous FICO Object
Next FICO Object
Get Balance
Get CCA Balance
Get New GL Balance
Get Classic GL Balance
Get PCA Balance
Company Code Name
Alternative GL Account
FICO Object Description
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Criteria – CCA Balance
Drill Using a Saved Template
Drill to Document
Drill to Line Item
Template Layout
Save Template Layout
Manage Templates
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Load CCA
Create Schedule
Running the Scheduler
SMTP Email Settings
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution

Calculating

The calculation buttons allow you to control exactly what cells are refreshed. They are used in conjunction with the refresh mode option (on/off).

Refresh Range, Sheet, Workbook or All

To calculate a range of cells simply:

  1. Highlight the range.
  2. Or select multiple ranges using the ctrl button (as normal in Excel).
  3. Or select a range and then select multiple Excel worksheets to calculate the same range on each sheet.
  4. Click the “Range” refresh 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:

  1. Select the applicable sheet.
  2. Or select multiple sheets to calculate each of the selected sheets.
  3. Click the “Sheet” refresh button.

To calculate a workbook simply:

  1. Select the applicable workbook.
  2. Click the “Workbook” refresh button.

To calculate all open workbooks simply:

  1. Click the “All” refresh button

Short cut 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.

Refresh Mode on or off

You can use the toggle button to control when requests for calculations are sent to the server. If you toggle GL Wand refresh mode to “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.

This is useful during report development. To calculate the results simply click one of the refresh buttons.

If you leave the GL Wand refresh mode “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 refresh mode option has nothing to do with Excel’s automatic and manual calculation. This 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.

Showing the last calculated value

You can control if the cells show their last calculated value or a pending status. See the GL Wand User Options section. This option is useful to display the last balance that was calculated the next time the workbook is opened. There are also many actions which trigger a calculation in Excel and this option can be used to retain the last calculated balances in the cells when one of these actions occurs. Use this option along with the Refresh Mode to set the calculation behavior that you prefer.

Depending on your selected options the Excel cells may not contain the latest balances from SAP. Always use the refresh buttons to calculate the formulas to ensure they have the latest balances.