Options

Overview

Several options are available to control certain features or the behavior of Velixo NX. Each setting is described in detail in this article.

Click the Options button in the Velixo NX Excel menu to summon the Options menu.

Refresh Behavior

• Refresh data when opening the file: When checked, a Smart Refresh will be performed when the workbook is opened (drawing in any data that is new in the ERP since the last refresh of the Velixo functions).

• Refresh external data sources and PivotTables when refreshing this workbook: When checked, this setting will automatically refresh both PivotTables and non-Velixo external data sources when using the Velixo NX Refresh feature.

• During Refresh → Current Sheet, also refresh any referenced worksheets: When checked (enabled by default), using Refresh → Current Sheet will cause the add-in to recursively explore any worksheets referenced by the current sheet and recalculate them first, ensuring that dependent data is up to date before the current sheet is refreshed.

Search and filtering

These options control how Velixo range expressions are parsed.

• Element delimiter: Changes the character used to separate elements in Velixo range expressions. The available options are: Comma and semicolon (default value), Comma, Semicolon, and Pipe (Business Central style).

• Range symbol: Changes the character used to denote ranges in Velixo range expressions. The available options are: Colon (default value) and Two dots (Business Central style).

Performance

Maximum number of simultaneous ERP data requests in Business Central

This setting controls how many data requests Velixo will send to Business Central at the same time. The value can be set between 1 and 32, with a default of 4. Increasing this value allows Velixo to fetch data from multiple endpoints in parallel, which can significantly reduce refresh times for workbooks with many independent queries. However, setting it too high may cause throttling by the Business Central API, resulting in slower responses or transient errors. If you encounter issues during refresh, try lowering this value.

Maximum number of simultaneous functions to process

This setting configures the maximum number of functions that Velixo will attempt to evaluate at any time. This can be adjusted to accommodate the resources available on your system.

Presentation

Blank rows in "Hide Zero Rows"

Controls how blank rows/columns should be handled after hiding zero rows/columns in a report. There are three possible settings:

• Preserve all blank rows (default value): Rows/columns with blank values will remain visible in the report.

• Hide all blank rows: Blanks will be treated the same as zeros, and those rows/columns will be hidden.

• Hide consecutive blank rows, keep at most one: All but the first of consecutive blank rows/columns will be hidden; only the first will remain visible in the report.

Missing identifier behavior

This setting determines if Velixo functions will return zero if one or more specified values are not found in the current tenant. This option is useful when creating reports consolidating data from multiple tenants with different configurations. You must refresh your report after changing this option.

Drilldown

Sheet destination

Controls whether drilldown sheets are created in the current workbook or if they are created in a separate workbook.

Writeback processing order

Controls the direction of traversing the worksheet during writeback processing. Options:

• Row by row (default value): all writeback formulas on the row will be calculated (left to right) before the next row will be calculated.

• Column by column: all writeback formulas in the column are calculated (top to bottom) before the next column is handled.

Clear cache and credentials

The Forget all connection credentials button allows you to require that new credentials be entered for all connections in the workbook.

Clear all Velixo data caches clears the cache for all connections.