Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Jet Express for Excel - Release Notes


Jet Express is a Microsoft Excel Add-in, included with Microsoft Dynamics NAV and GP, which gives users a simple way to create basic reports and business queries inside Excel. 

Here is a version-by-version list of change made to Jet Express for Excel.

Jet Express Overview

Express Help Topics

 

Jet Express (NAV) Jet Express (GP)

Jet Express 2017 R3 Build 17.2.17209.1
(August 3, 2017)

General Update

General Update

 

Jet Express 2017 R2 Build 16.1.17145.0
(May 31, 2017)

Installer

Fixed an issue where the Customer Experience Improvement (CEIP) window was not displayed on clean installation

Excel Add-in
Fixed an issue where a corrupted Settings.xml  file would generate multiple exceptions and, in turn, crash Microsoft Excel.

Installer

Fixed an issue where the Customer Experience Improvement (CEIP) window was not displayed on clean installation

Excel Add-in
Fixed an issue where a corrupted Settings.xml  file would generate multiple exceptions and, in turn, crash Microsoft Excel.

 

Jet Express 2017 R2 Build 16.1.17118.0
(May 4, 2017)

General Update

General Update

Jet Express 2017 R2 Build 16.1.17100.0
(April 14, 2017)

Excel Add-in
Fixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources.
Fixed an issue with NL(Sheets) where a sheet name with a ’:’ (colon) character would generate a COMException.
Fixed an issue in the Data Source Settings where creating a Dynamics NAV 2009 R2 or earlier data source cropped the text in the Data sources -> Advanced Settings window.
Fixed an issue in the Dynamics NAV 2009 R2 or earlier data source where Windows OS with certain regional settings caused dates to be retrieved incorrectly.

Excel Add-in
Fixed an issue in the Dynamics GP data source where a drilldown operation on a cell value of zero crashed Microsoft Excel.
Fixed an issue where Windows OS with certain regional settings were not supported with SQL-based data sources.

Jet Express 2017 R2 Build 16.1.17081.0 


Installer
Fixed issue where a COMException could occur during installation.

Jet Remote Data Service
Fixed issue where Jet Remote Data Service could not be installed on Windows Server 2008 or earlier.

Excel Add-in
Fixed issue in the Jfx where switching the type of function would not change the available inputs.
Fixed issue in the Excel Add-in where links to KB articles were incorrect.
Fixed issue in the Excel Add-in where double-clicking on the Pivot Table Icon on the Jet Ribbon would select the wrong item within the Pivot Table window.

 

Installer
Fixed issue where a COMException could occur during installation.

Jet Remote Data Service
Fixed issue where Jet Remote Data Service could not be installed on Windows Server 2008 or earlier.

Excel Add-in
Fixed issue in the Jfx where switching the type of function would not change the available inputs.
Fixed issue in the Excel Add-in where links to KB articles were incorrect.
Fixed issue in the Excel Add-in where double-clicking on the Pivot Table Icon on the Jet Ribbon would select the wrong item within the Pivot Table window.

 

Jet Express 2017 R2 Build 16.1.17061.0

Fixed an issue where reports that used NP(Union), NP(Difference), or NP(Intersect) with a Microsoft Dynamics NAV 2013 or later data source could result in an unexpected error.


Fixed an issue where reports with Microsoft Dynamics Nav 2009 and earlier data sources could not be run.

General Update

Jet Express 2017 R2 Build 16.1.17033.0

Initial Release of Jet Express 2017 R2

Initial Release of Jet Express 2017 R2

Jet Express 2017 Build 16.0.16354.0

Remote Data Service

Fixed issue in the NAV Remote Data Service where using Windows Authentication on the server caused the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

Excel Add-In

Fixed issue where conditional formatting was not preserved on a replicator row containing GL(Rows), GL(Columns), or GL(Sheets).

Jet Express 2017 Build 16.0.16293.1

 

Excel Add-In

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

 

Jet Remote Data Service

Fixed issue in NAV data sources where Jet functions querying tables that had multiple fields with the same caption returned #VALUE.

General Update

Jet Express 2017 Build 16.0.16287.0

 

Excel Add-In

Improved performance of certain types of FlowFields in the Dynamics NAV SQL data source.

Fixed issue in SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.
Fixed issue in Dynamics NAV SQL data sources where Code fields backed by a SQL Variant did not work correctly.
Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.
Fixed issue where database name drop-downs were not sorted alphabetically.
Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.

Jet Remote Data Service

Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

 

Excel Add-In

Fixed issue in SQL-Based data sources where Time fields would throw an ArgumentException, or always return 0.
Fixed issue where the NL(Table) function threw an IndexOutOfRangeException if one of the requested fields was blank.
Fixed issue where database name drop-downs were not sorted alphabetically.
Fixed issue where downgrading the Excel Add-In could result in an error when opening Excel due to an unrecognized Application Setting type.

 

 

Jet Remote Data Service

Added a Launch Condition to the MSI that requires the SQL Native Client to be installed.

Jet Express 2017 for Excel Build 16.0.16252.0

Added support for NAV 2017. Note that an updated version of the "Jet Reports Objects.fob" NAV objects must also be imported.
Improved overall performance of NAV Remote Data Service data sources.

Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected.
Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Fixed issue where grid drilldown into a Remote Data Service data source would display an empty grid.
Fixed issue where the "Auto Debug Report Errors" feature no longer worked as expected.
Fixed issue where the Table Builder would allow multi-selection for a filter value but would only select a single value.

Jet Express 2017 for Excel Build 16.0.16221.0

 

Updated the link to the Privacy Policy in the Activate Jet License window.

Fixed issue in the Dynamics NAV Remote Data Service data source where sorting by a CalcField did not work correctly.
Fixed issue in the Dynamics NAV SQL data source where filtering by an NAV Code field with properties Numeric=Yes and SQL Data Type=Variant may not retrieve the correct results.
Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.

 

Updated the link to the Privacy Policy in the Activate Jet License window.

Fixed issue in the Dynamics GP data source where functions containing SQL= may fail when the Batch Function Execution setting was enabled.
Fixed issue in the Dynamics GP data source where tables/views were always sorted by their physical name in the Table Builder and Jfx.
Fixed issue where orphaned workbook connections with associated PivotTables could cause E_INVALIDARG errors.

Jet Express 2017 for Excel Build 16.0.16196.0

Initial Release of Jet Express 2017 for Excel (NAV)

Initial Release of Jet Express 2017 for Excel (GP)

Jet Express 2015 Update 1 Build 15.1.16119.0

General Update.

General Update

Jet Express 2015 Update 1 Build 15.1.16098.0

Modified the Jet Setup to detect running applications and prompt the user to close them before proceeding.

Fixed issue where a Dynamics NAV GL function that specifies multiple companies may not give the correct value for a totaling account.
Fixed issue where clicking the Next button button after choosing "Activate via Email" in the Jet Activation window crashes Excel.

 

Modified the Jet Setup to detect running applications and prompt the user to close them before proceeding.

Fixed issue where clicking the Next button button after choosing "Activate via Email" in the Jet Activation window crashes Excel.
Fixed issue where NL(Table) throws an ArgumentOutOfRangeException when duplicate field identifiers are specified.

 Jet Express 2015 Update 1 Build 15.1.16054.0

 

Removed validation check for ambiguous field references that resulted in the message, "The identifier 'x' is ambiguous between two or more objects."
Improved installation experience when an issue is encountered with the Excel installation, formerly resulting in an InvalidExcelApplicationException.

Fixed issue where a lag could occur when switching between Excel workbooks.
Fixed issue where an ArgumentException could occur when running a report that contains a pivot table.
Fixed issue where the "Update Data Source" button would not work for a pivot table that was created using the Jet ribbon.
Fixed issue where Excel would fail to open files from Windows Explorer when both the Jet and Hyperion add-ins were installed.
Fixed issue where Excel tables that were not created by Jet would lose their data when refreshing the report.
Fixed issue where the Jet installer could give an error when using Swedish regional settings.
Fixed issue where Grid drilldown did not work in Dynamics NAV Remote Data Service data sources.
Fixed issue where double-clicking one of the Jfx buttons on the ribbon could crash Excel.

 

Removed validation check for ambiguous field references that resulted in the message, "The identifier 'x' is ambiguous between two or more objects."
Improved installation experience when an issue is encountered with the Excel installation, formerly resulting in an InvalidExcelApplicationException.

Fixed issue where a lag could occur when switching between Excel workbooks.
Fixed issue where an ArgumentException could occur when running a report that contains a pivot table.
Fixed issue where the "Update Data Source" button would not work for a pivot table that was created using the Jet ribbon.
Fixed issue where Excel would fail to open files from Windows Explorer when both the Jet and Hyperion add-ins were installed.
Fixed issue where Excel tables that were not created by Jet would lose their data when refreshing the report.
Fixed issue where the Jet installer could give an error when using Swedish regional settings.
Fixed issue where double-clicking one of the Jfx buttons on the ribbon could crash Excel.

 Jet Express 2015 Update 1 Build 15.1.16013.0

Fixed issue where duplicate fields could be loaded in a SQL-Server based data source, resulting in an AmbiguousIdentifierException when accessing the field.
Fixed issue where an exception could occur when accessing certain tables in the Dynamics NAV 2013 and later Web Services data source.
Fixed issue where the custom Jet message box could truncate text.

 

Fixed issue where Dynamics GP data sources could throw an SEHException when connecting to SQL Server 2012.
Fixed issue where duplicate fields could be loaded in a SQL-Server based data source, resulting in an AmbiguousIdentifierException when accessing the field.
Fixed issue where the custom Jet message box could truncate text.

 Jet Express for Dynamics 2015 Build 15.1.15350.0

 

Fixed issue where drilldown did not work in a Multitenant NAV Remote Data Service data source.

 

General Update

 Jet Express 2015 Build 15.1.15337.0

 

Improved the error message when attempting to connect to a NAVRDS with an invalid host name.

Fixed issue where Jet Setup would throw a COMException when Excel was not installed.
Fixed issue where NL(Table) threw an ArgumentException when switching companies.
Fixed issue where too many decimal places were displayed in the Jet data grid drilldown for NAV SQL data sources.
Fixed issue where the DataSource Settings Window and the New User Experience Window were cut off in the Windows 10.
Fixed issue where Excel crashed closing the JFx.
Fixed issue where the JFx stayed active when opening a workbook saved in Report-Mode.
Fixed issue where the NAVRDS data sources did not respect local date formats.
Fixed issue where Calc fields containing dimension fields inside an NF() for NavSqlDataSources threw a FieldNotFound exception.
Fixed issue where the Progress Window failed to appear and the Report Runtime was 00:00'00 when running a report.
Fixed issue where grid drilldown does not work on a formula containing a flowfield in a field cache.
Fixed issue where the table record count only returned the count for the first company in a NAV 2013 Web Service Data Source.
Fixed issue where NAVSQL data sources threw an Invalid Field error when a dimension value contained special characters.
Added a link to a KB article for users who can create and connect to a NAVSQL data source but receive an error stating that the "data provider cannot be found" when designing reports.
Fixed issue where Serenic User Access Rules were not being respected for NAV 2013 and later databases.

 

Changed the GPRDS data source to require Essentials.
Changed Jet to throw an error message when a query is made using an ambiguous table or field identifier. Depending on the data source this could be the number, name, or caption.

Fixed issue where Jet Setup would throw a COMException when Excel was not installed.
Fixed issue where NL(Table) threw an ArgumentException when switching companies.
Fixed issue where the DataSource Settings Window and the New User Experience Window were cut off in the Windows 10.
Fixed issue where Excel crashed closing the JFx.
Fixed issue where the JFx stayed active when opening a workbook saved in Report-Mode.
Fixed issue where the Progress Window failed to appear and the Report Runtime was 00:00'00 when running a report.

 

 Jet Express 2015 Build 15.1.15308.0

 

Added KB article links for various messages.

Fixed issue where a COMException was thrown when refreshing a report with a Pivot table based on a SQL database was in a report.
Fixed issue where a COMException was thrown when a HideSheet tag was on the active worksheet and the report was refreshed.
Fixed issue with batch optimization in the NAVRDS where NF functions returned #VALUE when one or more of the record keys was blank.
Fixed issue with batch optimization in the NAV Web Service data source where an NF returning the primary key value from a scalar record function returned #VALUE.

Added KB article links for various messages.

Fixed issue where a COMException was thrown when refreshing a report with a Pivot table based on a SQL database was in a report.
Fixed issue where a COMException was thrown when a HideSheet tag was on the active worksheet and the report was refreshed.

 Jet Express 2015 Build 15.1.15265.0

 

Changed the Remote Data Service installer to require PowerShell 4.0.

Fixed issue where a Pivot table based on an NL("Table") would leave extra data on a report.
Fixed issue where a Pivot table based on Jet data would throw an error when using PowerPivot data.
Fixed issue where a Pivot table based on Jet data would throw the error "The workbook connection 'LinkedTable_Table1' could not be updated for the following reason: Exception from HRESULT: 0x800A03EC."
Fixed French translation of the Table Builder Supertip.
Fixed typo in the Jet log file (data soure type => data source type).
Fixed issue where the Jet Ribbon would disappear when the JFx was open and the user interacted with Excel's formula bar.

Changed the Remote Data Service installer to require PowerShell 4.0.

Fixed issue where a Pivot table based on an NL("Table") would leave extra data on a report.
Fixed issue where a Pivot table based on Jet data would throw an error when using PowerPivot data.
Fixed issue where a Pivot table based on Jet data would throw the error "The workbook connection 'LinkedTable_Table1' could not be updated for the following reason: Exception from HRESULT: 0x800A03EC."
Fixed French translation of the Table Builder Supertip.
Fixed typo in the Jet log file (data soure type => data source type).
Fixed issue where the Jet Ribbon would disappear when the JFx was open and the user interacted with Excel's formula bar.

 Jet Express 2015 Build 15.1.15224.0

 

General Update

General Update

 Jet Express 2015 Build 15.1.15217.0

 

Updated Japanese Translations.
Fixed performance issues with the Dynamics NAV SQL data source (introduced in 15.1.15204.0).

 

General Update

 Jet Express 2015 Build 15.1.15204.0

 

Updated product translations.
Added preliminary support for Microsoft Excel 2015.
Improved error message that is displayed when a company is not selected.

Fixed issue where Excel pivot tables where updated every time the workbook was activated.
Fixed issue where the NP function would not report an appropriate error when used in Jet Express.

 

Updated product translations.
Added preliminary support for Microsoft Excel 2015.
Improved error message that is displayed when a company is not selected.

Fixed issue where Excel pivot tables where updated every time the workbook was activated.
Fixed issue where the NP function would not report an appropriate error when used in Jet Express.

 Jet Express 2015 Build 15.1.15181.1

 

Made the Dynamics NAV SQL Multitenant Data Source type available in Jet Express.

General Update

Jet Express 2015 Update 1 Build 15.1.15166.0  

 

General Update

General Update

Jet Express 2015 Update 1 Build 15.1.15148.0 

 

General Update

General Update

Jet Express 2015 Update 1 Build 15.1.15131.0

Update to correspond with release of Jet Essentials 2015 Update 1

Includes: NAV SQL Server Connector

General Update to correspond with the release of Jet Essentials 2015 Update 1

 Jet Express 2015 Build 15.0.15091.0

 

General Update

General Update

Jet Express  2015 Build 15.0.15063.0 

 

General Update

General Update

 Jet Express 2015 Build 15.0.15019.0

 

General Update

General Update

 Jet Express 2015 Build 15.0.14357.0

 

General Update

General Update

 Jet Express 2015 Build 15.0.14329.0

 

General Update

General Update

 Jet Express 2015 Build 15.0.14295.0

 

Updated product translations.
Fixed issue where the Dynamics NAV GL function could throw an OverflowException.

General Update

 Jet Express 2015 Build 15.0.14280

Update to correspond with release of Jet Essentials 2015

Compatibility with NAV 2015
Support for NAV 2015's Office 365 authentication method (also known as OAuth authentication)

Update to correspond with the release of Jet Essentials 2015

 Jet Express 2013 Update 1 Build 14.1.14226.0

Updated product translations.

Fixed issue in the Dynamics NAV SQL data source where a SQL error could occur when using a LinkField against a nested link that uses multiple fields to join the table.

 

General Update

 Jet Express 2013 Update 1 Build 14.1.14177.0

 

Fixed issue in the installer where attempting to upgrade Jet Express could result in an MSI error.
Fixed issue in the Dynamics NAV Web Service data source where filters on Decimal fields were not correct in locales that use a comma (',') as decimal separator.
Fixed issue in the Jfx where picking up a function with more than 10 FilterField/Filter pairs would throw an ArgumentOutOfRangeException.
Fixed issue in the Table Builder where double-clicking the scrollbar when looking up a table would cause the popup window to close.
Fixed issue in the Jfx/Table Builder where double-clicking the resize handle of a popup would cause erratic behavior.

 

Fixed issue in the installer where attempting to upgrade Jet Express could result in an MSI error.
Fixed issue in the Jfx where picking up a function with more than 10 FilterField/Filter pairs would throw an ArgumentOutOfRangeException.
Fixed issue in the Table Builder where double-clicking the scrollbar when looking up a table would cause the popup window to close.
Fixed issue in the Jfx/Table Builder where double-clicking the resize handle of a popup would cause erratic behavior.

 Jet Express 2013 Build 14.1.14133.0

 

General Update

 

General Update

 Jet Express 2013 Build 14.1.14114.0

 

General Update

 

General update

 Jet Express 2013 Build 14.0.14042.0

 

Updated the translation for "NAV 2013 and later" in Dutch and Icelandic to remove erroneous "R2".

Fixed issue where a NullReferenceException could occur after a report is run when a cell containing an Excel (non-Jet) formula was selected.
Fixed issue with NP(Codeunit) and Dynamics NAV 2013 data sources where an AppDomainUnloadedException could occur.

 

Added optional SQL Native Client 2012 prerequisite for use with SQL Server 2012.
Fixed issue where a NullReferenceException could occur after a report is run when a cell containing an Excel (non-Jet) formula was selected.

 Jet Express 2013 Build 14.0.14024.0

 

Fixed issue with Dynamics NAV 2013 data sources where an NF function would give an InvalidCastException when the primary key contains a Boolean value.
Fixed issue with Dynamics NAV data sources where an IndexOutOfRangeException may occur during drilldown if the company name contained a special character.
Fixed issue with Dynamics NAV data sources where an ArgumentNullException could occur if the Dimension table contained a blank Code.

 

General Update

 Jet Express 2013 Build 14.0.13337.0

 

Updated French translation.
Added a message to the Data Source Settings indicating the response time on Test Connection of NAV data sources.

Fixed issue where CalcFields in NAV 2013 data sources were case-sensitive when searching for embedded NF functions.
Fixed issue where Option fields were returned as numbers instead of captions in NAV 2013 data sources.
Fixed issue where user is prompted for credentials when login fails for a NAV data source, even when using Windows Authentication.

 

General Update

 Jet Express 2013 Build 14.0.13276.0

 

Updated French translation.
Updated installer translations for all supported languages.

Fixed issue with NL(Table) where invalid characters in the table name using TableName= could cause existing Pivot Tables to lose the table reference.

Updated French translation.
Updated installer translations for all supported languages.

Fixed issue with NL(Table) where invalid characters in the table name using TableName= could cause existing Pivot Tables to lose the table reference.

 Jet Express 2013 Build 14.0.13249.0

 

Updated product translations for all supported languages.

 

Updated product translations for all supported languages.

 Jet Express 2013 Build 14.0.13231.0

 

Fixed issue with the Dynamics NAV GL function where accounts with the account type of "totaling" always returned 0.
Fixed issue with the GL function and NL(Sum) where an error occurred when specifying a company name that contains special characters.

 

General Update

 Jet Express 2013 Build 14.0.13222.0

 

Fixed issue with batch query execution where functions may return #VALUE! when using a Dynamics NAV 2013 data source.

 

General Update

 Jet Express 2013 Build 14.0.13203.0

 

Fixed issue where a COMException occurred when specifying a table name with NL(Table) in Excel 2003.
Fixed issue in Jfx where the last item in the lookup would be cut off.

 

Added compatibility for Dynamics GP data sources running on Microsoft SQL Server 2012.

Fixed issue where a COMException occurred when specifying a table name with NL(Table) in Excel 2003.
Fixed issue in Jfx where the last item in the lookup would be cut off.

Jet Express 2013 Build 14.0.13169.0 

 

 Updated Czech translation of the "Connection=" tag so that it is not the same as "Link=".

 

Updated Czech translation of the "Connection=" tag so that it is not the same as "Link=".

 Jet Express 2013 Build 14.0.13135.0

 

Fixed issue where Jet Express was unable to be installed on a machine containing 64-bit version of Office 365.

 

Fixed issue where Jet Express was unable to be installed on a machine containing 64-bit version of Office 365.

 Jet Express 2013 Build 14.0.13102.0

 

Updated product translations for all supported languages.

Merged fixes from Jet 2012 R2 Build 12.5.13099.0.

Fixed issue in Jfx where an InvalidOperationException could occur, causing the window to hang.

 

Updated product translations for all supported languages.
Changed GP Update Utility to overwrite Jet roles if they already exist, and removed access to Jet Views from the Jet All Users role.
Merged fixes from Jet 2012 R2 Build 12.5.13099.0.

Fixed issue in Jfx where an InvalidOperationException could occur, causing the window to hang.

 Jet Express 2013 Build 14.0.13088.0

 

Improved performance for all data sources types when the query contains the primary key.
Improved performance of searching for Jet tags in other languages.

 

Improved performance for all data sources types when the query contains the primary key.
Improved performance of searching for Jet tags in other languages.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments