Contact Us
Index
Version 21.2
Version 5.1 Version 5.0 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.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
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V21.x to V4.x
Toggling from V4.x to V21.x
License Key Errors
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Snapshot
Shared Templates Drive
Drive Types
Navigator
Dropbox
File Server
Create a File
SAP Database
Delete a File
Edit a File
Open a File
Common Options
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Report Wizard
Add Columns
Design Layout
Add Rows
Report Wizard Output
Discover FICO Object Values
Expand/Explode Level
Expand and Explode
Expand FICO Object Values
Expand FICO Object Value Hierarchy
Explode FICO Object Values
Explode FICO Object Value Hierarchy
List of Values – Create
Get Balance
Get Classic GL Balance
Get New GL Balance
Get Daily GL Balance
Get CCA Balance
Get PCA Balance
Get COPA (CB) Balance
Get Internal Order Balance
Get Activity Type Balance
Get Project Balance
Get SKF CCA Balance
Get SKF IO Balance
Get Universal Journal Balance
Get Overall Plan Balance
Get SKF PCA Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next FICO Object
Next COPA (CB) Object
Get Exchange Rate
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Drill Criteria Sheets
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand User Options
Other Tools
Hide Zeros
Clean Template
Manage Criteria Templates
Configuration Sheet
Create Report
Execute Report
Insert Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh Reports Wand Functions
Refresh Mode
Parameter List
Report Editor
Template Manager
Reports Wand User Options
Report Definition
Create
Edit
Load CCA
Load PCA
Load New GL
Load Activity Input
Load Activity Output
Load SKF
Load S4 Financial
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution
Create Schedule
Running the Scheduler
SMTP Email Settings

Reports Wand User Options

Configure your user preferences.

 

Option Description
Calculation drills to new workbook When enabled, drilling down from a function (calculation) will populate the results into a new workbook.
Drilldown drills to new workbook When enabled, drilling down from a previous drilldown report will populate the results into a new workbook.
Double click enabled When disabled, a double click in Excel will no longer open lists of values and execute drilldowns.

Changes to this option are only effective at the next logon or after changing company code.
With this setting enabled, double clicking in a cell that does not contain an Wands drilldown function or list of values will always result in the cell being put into edit mode. Excel’s option to select the cells that are referenced by the active cell will be disabled.
Show last calculated values Shows the last calculated value, if available, when performing an action that triggers an Excel calculation (except using the refresh buttons which always calculates a new result).
Auto refresh when workbook opened By default a workbook will not calculate Wands formulas when it is opened. This option can be used to control this behavior.

Please note that the first time you open a workbook with this new version it may still calculate irrespective of this setting. If this occurs simply calculate and save the workbook to convert it to the new process.
Disable Excel multi-threaded calculation mode When ticked, the Excel multi-threaded calculation mode will be disabled when a calculation is performed using one of the Wands refresh buttons.