Workbook Design Mode

Revision as of 08:54, 15 July 2021 by CFrance (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

This is a feature available from Version 8 which allows you to make multiple changes to your report without running grids or table. This is useful for large/complex workbooks which run slowly.

It can be enabled through the XLCubed -> Options -> Workbook Options form. Alternatively, you can open a workbook in design mode by holding the Ctrl key to access the Advanced Workbook Open Options.

With this enabled you are able to design grids and tables, and edit member selections without needing to run the queries.

Grids and tables will only be run when explicitly told to , for example through the Refresh buttons. Changes to slicers or driving cells will not cause them to be updated.