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. |
| Display technical field names | When selected, the technical table and field name are included in the column description of the report output. |