Skip to main content

App Settings (Application Settings)

Overview

The App Settings are user preferences and other application-wide settings that affect the behavior of the Jet Excel add-in.

General

User Interface Language

The supported language used in the Jet user interface

(Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hungarian, Icelandic, Italian, Japanese, Norwegian, Polish, Portuguese, Russian, Spanish, or Swedish)

Lookup Sample Value Limit The maximum number of sample values that will be retrieved when performing a lookup.
Lookup Record Scan Limit

The maximum number of records that will be scanned in order to retrieve sample values when performing a lookup.

Applies to Dynamics NAV data sources only.

Show Data Sources in Toolbar

Determines whether the default data source, and company if applicable, can be selected from the Jet ribbon or toolbar.

Auto Debug Report Errors

Determines whether Jet automatically scans the report for #VALUE! errors after running reports and display a diagnostic message.

Run Scheduler as Administrator

Due to permissions updates (KB2836942 and KB2836943) for the Windows Task Scheduler published by Microsoft for Windows XP and higher, the Jet Scheduler must be launched with Admini rights if tasks will be scheduled to run when the user is logged out of Windows.

Simulation Mode

None : Operates the Jet Excel add-in normally.

Viewer : Removes design privileges so that a Designer can test reports before they are distributed to report Viewers.

Jet Reports Financials : Operates the Jet add-in as though it were Jet Reports Financials.

Snippets Folder Specifies the folder in which snippet files are saved.

License

Displays current Jet license information.

Excel

Preserve Page Breaks

Determines whether Jet will replicate page breaks occurring within a replicator region. This should only be enabled if necessary as it can have a significant performance impact

Preserve conditional formatting in Excel 2010 and later

Determines whether Jet will preserve conditional formatting in Excel 2010 and later. This should only be enabled if necessary as it can have a significant performance impact

Always remove Excel AutoFilters

Determines whether AutoFilters will be removed during a report run.

Show Compatibility Mode Warning

Determines whether Jet will display a warning message about the issues associated with running Excel in compatibility mode

Show AutoFilter Warning

Determines whether Jet will display a warning message prompting users to remove AutoFilters before running a report.

Show data overwrite warning when dropping Snippets or Fast Financials accounts

Determines whether Jet will display a warning message when data will be irrevocably overwritten when using the drag-and-drop feature of either the Snippets of Fast Financials Tool.

This page is used to configure how Jet sends email via SMTP using the Scheduler feature.

SMTP

This page is used to configure how Jet sends email via SMTP using the Scheduler feature.

Settings Location

Specifies the location in which Jet data source settings are stored.  Settings can be stored in the local user profile or in a centralized SQL Server database, which allows for sharing of data sources, metadata, and other settings between users. See the Centralized Settings section for more information.

Logging

This page is used to configure Jet logging.  Logging will negatively impact report performance and can produce very large files.  It should only be enabled when directed by Jet Support, and should be disabled when no longer needed.

Performance

Disabling these settings can negatively impact report performance and is not recommended unless directed by Jet Support.

Enable Batch Function Execution

Instructs Jet to evaluate certain types of functions within a report in batches, providing a performance improvement under certain reporting scenarios.

Cache Function Results

Instructs Jet to cache function results while running a report. Jet functions may be evaluated 3 times or more during a report run, so caching the values during the report run improves performance. Cached results can grow very large and cause Excel to run out of memory for very large reports on 32-bit systems.

Enable Excel Automatic Calculation When Restoring Formulas

Instructs Jet to enable automatic Excel calculation when restoring formulas when entering design mode. This should make entering design mode or running reports from report mode faster

Disable Excel Multi-Threaded Calculation When Running Reports

Instructs Jet to disable Excel multi-threaded calculation when running reports. Excel’s multi-threaded calculation can cause formulas to evaluate prematurely, resulting in errors and re-calculations.

This only applies to older versions.  Jet Reports 2019 and higher utilized multi-threaded calculations under most circumstances.

Enable cache tables for Nav/Business Central Web Services data sources

This setting instructs Jet to enable the Table Cache Optimization while running a report, improving the report performance for Web Services data source connections. This only applies to Dynamics NAV and Business Central Web Services data sources.

Jet Ribbon

Allows the user to choose which buttons appear on the Jet ribbon.

Updates

Determines whether a notification will be displayed in the Jet ribbon when a newer version of Jet is available.

Related Articles

Was this article helpful?

We're sorry to hear that.