| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Advanced Workbook Open Options"
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
From [[Version 8]], XLCubed allows you to have more control when opening a workbook. To access these advanced options, hold down the {{Menu|Shift}} key when opening the workbook. | From [[Version 8]], XLCubed allows you to have more control when opening a workbook. To access these advanced options, hold down the {{Menu|Shift}} key when opening the workbook. | ||
| + | |||
| + | [[Version 9]] now uses the {{Menu|Ctrl}} key and includes the "Disabled XLCubed" option without needing to enable it first | ||
[[File:AdvancedWorkbookOpen.png|center]] | [[File:AdvancedWorkbookOpen.png|center]] | ||
| Line 7: | Line 9: | ||
;Disable XLCubed for this workbook | ;Disable XLCubed for this workbook | ||
:Prevents any XLCubed functionality from running while this workbook is active. This includes all data access, formulae and dialogs. This option is hidden by default. To enable it, select the {{Menu|XLCubed|Options|XLCubed Options|User Interaction tab|Hold Shift key to disable workbooks while opening}} option. | :Prevents any XLCubed functionality from running while this workbook is active. This includes all data access, formulae and dialogs. This option is hidden by default. To enable it, select the {{Menu|XLCubed|Options|XLCubed Options|User Interaction tab|Hold Shift key to disable workbooks while opening}} option. | ||
| + | ;Enable 'design mode' for this workbook | ||
| + | :Turns on [[Workbook Design Mode]]. XLCubed functionality will still be available but no queries will be run unless explicitly told to. | ||
;Continue normally | ;Continue normally | ||
:XLCubed will continue to run as usual | :XLCubed will continue to run as usual | ||
Latest revision as of 09:05, 15 July 2021
From Version 8, XLCubed allows you to have more control when opening a workbook. To access these advanced options, hold down the Shift key when opening the workbook.
Version 9 now uses the Ctrl key and includes the "Disabled XLCubed" option without needing to enable it first
- Manage the workbook connections
- Allows you to edit or remove any invalid connections in the workbook before XLCubed attempts to connect or refresh any data.
- Disable XLCubed for this workbook
- Prevents any XLCubed functionality from running while this workbook is active. This includes all data access, formulae and dialogs. This option is hidden by default. To enable it, select the XLCubed > Options > XLCubed Options > User Interaction tab > Hold Shift key to disable workbooks while opening option.
- Enable 'design mode' for this workbook
- Turns on Workbook Design Mode. XLCubed functionality will still be available but no queries will be run unless explicitly told to.
- Continue normally
- XLCubed will continue to run as usual
