: Create complex data filters and select specific columns without writing a single line of SQL.

To ensure a seamless transition and apply the fixes cleanly without losing your existing query configurations, follow this deployment workflow: Step 1: Backup Local Workbooks and Connection Strings

“Upgrading to v244150 resolved the v244120 bug with Salesforce connection timeouts. Sometimes the best fix is moving forward.” —

While Devart frequently updates its connectors to maintain compatibility with shifting API requirements, the core improvements in recent builds typically address: Enhanced Data Refresh

If you are experiencing specific error codes, please list them below. Are you using the Oracle, Salesforce, or NetSuite version?

To ensure version 2.4.4.120 runs optimally and avoids common "add-in not showing" errors: Enable the Ribbon : If the Devart tab does not appear, go to File > Options > Add-ins

, allowing for more advanced SQL statements that cannot be translated directly to a cloud provider's native API. Connection Reliability : Added the Failover Retries

Open the Windows and navigate to Programs and Features .

This report documents fixes included (or likely included) in the Devart Excel Add-ins build/version v244120, evaluates their impact, and provides recommended best practices for deployment, testing, and ongoing maintenance. Where specifics are not explicitly available from release notes, reasonable assumptions are made based on common bug patterns for Excel add-ins and previous Devart releases.

: Force-enable the ribbon using Excel Options if the Devart tab disappears after a crash.

Here is a deep dive into that feature:

| Issue Area | Previous Behavior (Pre-24.4.120) | Fix in v24.4.120 | |------------|----------------------------------|-------------------| | | Long-running queries would drop during refresh, losing all unsaved work. | Timeout handling is significantly improved; large datasets now refresh without random disconnects. | | Parameter Binding | Named parameters in SQL (e.g., @startDate ) failed when reusing the same cell reference across multiple queries. | Parameter mapping is now persistent. No more “parameter not found” errors on second refresh. | | Excel 365 (Current Channel) | Add-ins would occasionally fail to load or freeze on the “Loading data” spinner. | Full compatibility with the latest Excel 365 monthly channel builds. | | Data Type Preserving | Date/time columns sometimes reverted to plain text or general format after refresh. | Column formatting (including custom number formats) now survives a refresh. |

: To receive official stability and security fixes, it is recommended to use the latest version available on the Devart Revision History page.