GL Wand User Options

Configure your user preferences.

Option	Description
Show disabled	Include disabled segment values when discovering, expanding or exploding and in lists. Play Video
Show secured	Include secured segment values when discovering, expanding or exploding and in lists.
Treat end dated segments as disabled	If a segment value has a “From” or “To” date specified which falls outside the current date then treat it the same as a disabled segment value.
Show segment criteria errors	If you enter segment criteria which does not exist in the list of segment values, the GL Wand function will return an error message. If you would prefer that the function returns an empty string (or zero balance when applicable) then disable this option. By disabling this option you acknowledge that you are aware of the fact that GL Wand will return a zero balance in the Get Balance function when the segment criteria that you enter does not match any segment values.
Hierarchy level spans columns	When populating expand hierarchy results, span the hierarchy levels across columns.
Calculation drills to new workbook	When enabled, drilling down from a function (calculation) will populate the results into a new workbook. Play Video
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 responsibility. 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.
Add a dummy line for unsupported drilldowns	Adds a dummy line to a drilldown where the source line was not supported.
Suppress zeros on drilldown	Exclude items in the balance drilldown report if the opening balance, dr movement, cr movement and closing balance are all zero.
Conditionally populate Drill To Journal Attachments link	When enabled, the Drill to Journal Attachments link populates only if attachments exist for the journal. When disabled, the link populates regardless of whether attachments exist for the journal or not. This option is disabled by default. Enabling conditional population may impact drilldown performance.
In-Memory Options Enable	Enable or disable the in memory database option. Play Video
Maximum Age	Items from the In-Memory database that have not been accessed for the specified number of days will be discarded.
In-Memory Clear	Clear the In-Memory database. You must unlock the option by clicking thelock first.
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). Play Video
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	Disables Excel’s multi-threaded calculation mode during an Wands calculation. Due to an Excel bug, which has not yet been addressed by Microsoft, an error can occur during the calculation of larger, more complex reports. The error manifests as an “Out of resources” message or an Excel crash which occurs during the process where the results of Wands functions are returned to Excel. Disabling the multi-threaded calculation mode is a workaround to avoid this bug. The overall effect on calculation time should be minimal as the results are returned to Excel in-between processing other calculations. The bug does not affect all reports and you may therefore uncheck this option should you wish. However if you experience the Excel bug then checking this option will be required.