For each workbook, you can modify workbook-level options.
Workbook tab
Option | Description |
Design Mode | Allows you to change the grid without running the query behind it |
Overtyping a grid creates an Alias | Overtyping a member name creates an alias for it. |
Available Actions - Ignore multiple filter members | If this setting is enabled, the available actions will only use the first member of each filter hierarchy (if more than one member is selected). This can speed up the action form's display if many members are selected. |
Get unique names from formula ranges | Grids, Slicers, and other Anaplan XL objects will try to get the unique name from any formulas in the ranges they're driven from. |
Slicers output numbers | When output to a cell, the output will be values rather than text. |
Maximum calculation depth during grid refresh | If a workbook has "Circular" dependencies in grids, then this setting controls the maximum number of times to recalculate the same grid. |
Worksheet protection password | Setting the password value used to "protect" the worksheets will enable Anaplan XL to unprotect the sheets during grid refreshes. The sheets are protected again after the refresh is completed. |
Limit comments by key | Limits the Cube Comments made and retrieved in the workbook to the specified key. |
Comments Web Server | location of web server for commentary |
Reset Format Sheet | This removes any customized formatting from the workbook by replacing the existing FormatSheet sheet with the default sheet as defined in Options > Anaplan XL Options > Main. |
PowerPoint settings tab
You can now create a workbook to support exporting to PowerPoint. This needs to be set here:
- Allow save to PowerPoint slideshow: enable save/export to PowerPoint
- Slides: add appropriate workbook range for each slide that'll be created
- Use slide title: specify static text or cell range to use as slide's title
- Resize content to fit space: enable to fit slide space available and optionally retain aspect ratio
External data
Allows data to be pulled from an external set of workbooks.