Options Menu


The tabs in the Options menu allow you to customize some features of the Jedox Excel Add-in, such as language and file locations. Note that changes to language and controls take effect only after restarting Excel. Other changes take effect immediately.  

General Options tab

Jedox version check: checks for updates when Excel is opened. When unchecked, a link is displayed, allowing you to manually check for the latest version of Jedox. 


  • Enable Excel status bar messages
  • Use defined style for locked OLAP cells
  • Always use rule-calculated values for copy, like, and predict operations
  • Language
  • Style path
  • Log path (this option affects logging of Excel and Office Add-in)
  • Connection, license activation, and password changes
Dialog Options tab

Controls: when selected, it opens the options “More” in the Paste View, Paste Elements, and Select Elements dialogs.

Sort order of cubes: sets the default sort order for cubes in all dialog windows.

Paste View options:

  • Display gridlines: preselects the “Display gridlines” option under Layout Options in the Paste View dialog.
  • Expand all nodes: if set, double-clicking the left mouse button expands/collapses one level of all nodes with the same name. Several identical names can be found in inner dimensions of row titles or column titles in a Jedox view. If not set, double-clicking the left mouse button expands/collapses only one level of the current node.
  • Use the element name path: preselects the “Use element name path” option under Layout Options in the Paste View dialog.

GPU Accelerator Advisor:

  • Timeout (seconds): time limit for the GPU Accelerator Advisor to check if the selected cube is suitable for GPU. If the check exceeds the given time, the Advisor cannot give any recommendation.
Modeler Options tab

Delete cache when closing Excel: when selected, deletes cached files from the web-based dialogs (commands Modeler, Publish, Edit Jedox Spreadsheet) whenever Excel is closed. By default, the option is not enabled.

Before downloading a file, always ask where to save it: if set, a user is prompted for a storage folder whenever a file is exported from Modeler (e.g. cube/dimension download, or database script). If the option is disabled, it can be defined as a default folder for all by Jedox downloaded files.