Devart Excel Add-ins History

2.10.1404 08-Oct-24

Added support for Salesforce Web Services API version 59.0
Added support for Shopify API version 2024-04
Significantly improved the performance of importing data to Excel from relational databases and fast cloud services
Introduced a new parameter, "Warn about tables without columns that uniquely identify rows," now available under Options -> Edit -> General
Introduced a new parameter, "Show connection string" option (by default: True), now available under Options -> Edit -> Error Handling
Introduced a new parameter, "Show sensitive info in connection string" option (by default: False), now available under Options -> Edit -> Error Handling
Added a new "Copy Log" button in the Execution window
Added a new GiftCards table for Shopify
Added new read-only tables for HubSpot: Invoices, InvoiceLineItems, LineItemInvoices, Teams, and Users
Added new tables for FreshBooks: BillVendor, Bill, BillLine, and BillPayment
Resolved an issue with connecting to Oracle 19 and higher in Direct mode when using Oracle Encryption or Oracle Data Integrity (Oracle)
Resolved an issue with the TLS certificate chain received from remote servers like Amazon RDS for MySQL and Amazon RDS for MariaDB (MySQL)
Resolved an issue with the TLS certificate chain received from remote servers like Amazon RDS for PostgreSQL and Amazon Redshift (PostgreSQL)

2.9.1323 27-Feb-24

Excel Add-in for Zoho Books has been released
Excel Add-in for Zoho Desk has been released
Oracle 23c has been supported
MariaDB 11 has been supported
PostgreSQL 16 has been supported
SQL Server 2022 has been supported
Excel Add-in for Magento has been renamed to Excel Add-in for Adobe Commerce
Excel Add-in for QuickBooks has been renamed to Excel Add-in for QuickBooks Online
A new "Do not validate single update/delete per row on commit" option has been added to Options -> Edit -> Error Handling
Support for NetSuite 2023.2 Release has been implemented
Zendesk Custom Lookup Fields have been supported
Filtering and caching for V3 Product-related tables in BigCommerce have been optimized
When updating the Purchase object in QuickBooks, the required parameter PaymentType is now passed
Two-factor authorization is now supported for Adobe Commerce
A new field, CostRate, has been added to the TimeActivity object in QuickBooks
A new field, Phone, has been added to the Customers object in Shopify
The buffering error that occurred when updating the Shopify Products table has been fixed
The issue with detecting function-based column default values in PostgreSQL has been resolved
The issue with detecting string literals as column default values in PostgreSQL has been resolved
The issue with detecting string literals with data type casting as column default values in PostgreSQL has been resolved
The issue with detecting column default values as numeric and string literals, specified within round brackets or quotes, has been fixed
The issue of additional columns appearing in query results in PostgreSQL has been resolved
The issue with QuickBooks connection has been fixed
The issue with reading the BigCommerce Pages table has been resolved

2.8.1140 15-Aug-23

MariaDB 10.10 is supported
PostgreSQL 15 is supported
Zoho CRM API v4 is supported
Added support for Custom App authorization (Shopify)
Added support for Private App authorization (HubSpot)
Salesforce Web Services API version 55.0 is supported

2.7.940 22-Sep-22

Fixed bug with Web Login authorization (HubSpot)

2.7.939 21-Sep-22

Windows 11 official support
Compact installation function added
Excel Add-in for Microsoft Dynamics CRM - renamed to Excel Add-in for Microsoft Dynamics 365
In-built encryption support for SQLite databases implemented: AES-128, AES-192, AES-256, Blowfish, CAST-128, RC4, Triple DES
The default browser is used for the Web Login authorization
New "Buffer size" parameter id added to Option -> Import -> Data -> General
The error when reading the Shopify table InventoryLevels is fixed
Usability improved: it is possible to see the saved SQL if the connection to the server is lost
The TicketMetricEvents object is added (Zendesk)
The PriceListRecords object support is improved (BigCommerce)
The Wishlists, WishlistItems, PriceListAssignments, and OrderMetaFields objects are added (BigCommerce)
COQL Query for Zoho CRM is supported to speedup the process of query execution. COQL is available for the following objects: Accounts, Contacts, Deals, Campaigns, Tasks, Cases, Events, Calls, Solutions, Products, Vendors, PriceBooks, Quotes, SalesOrders, PurchaseOrders, Invoices (Zoho CRM)
The new "Query API" connection parameter is added (Zoho CRM)
Parent Company - Child Company connection importing - now supported (HubSpot)
Fixed bug with Orders and DraftOrders tables (Shopify)
Fixed bug with "Unexpected SugarType 'autoincrement'" error (SugarCRM)
Fixed bug with the error of reading data from Invoices and InvoiceProductDetails tables (Zoho CRM)
Fixed bug with SELECT query with WHERE clause (Zendesk)
Fixed bug with missing primary key in metadata (Marketo)

2.6.791 20-Dec-21

Microsoft Excel 2021 is supported
Added modern encryption algorithms for MySQL and PostgreSQL
Excel Add-in for G Suite is renamed to Excel Add-in for Google Workspace
People API for Google Workspace is supported
The DealsStageHistory read-only table is added (Zoho CRM)
New App for Dynamics CRM signed by Microsoft
New BigCommerce table ProductCustomsInformation was added
The bug with OrderDetails object filtering by OrderId is fixed (Shopify)

2.5.704 13-Aug-21

Salesforce Web Services API version 52.0 is supported
ServerToServer Authentification Type was added to main Salesforce Marketing Cloud connection parameters
The field "NoteAttributes" of the "Orders" object and the field "Properties" of the "OrderDetails" object were added according to updates in Shopify API (version: 2021-04)

2.5.660 10-Jun-21

The ContactDetails object is added, it extends Contact with the additional columns Avatar, ViewAllTickets, Tags, OtherEmails, OtherCompanies (Freshdesk)
The Tags field is added to the Ticket object (Freshdesk)
The bug with multicolumn CONSTRAINT UNIQUE in PosgreSQL tables is fixed

2.5.609 31-Mar-21

The list of available domains in Connection Editor is supplemented with crm.zoho.com.au and crm.zoho.in (Zoho CRM)
The objects DynamicContentItem and DynamicContentItemVariant are added (Zendesk)
The bug with the "Unexpected SugarType 'call-recording'" error is fixed (SugarCRM)

2.5.572 28-Jan-21

Token server is supported for FreshBooks
New entity "current_total_price_set_presentment_money" is supported for Shopify Orders
New field "Tags" is added to Freshdesk Ticket
New option "Save line breaks in multi-line text cells as" is added to Options -> Edit
The behaviour is changed: currently line breaks are saved as CR LF
The bug with "Unexpected SugarType 'discount-amount'" error is fixed for SugarCRM
The bug with "Page cannot be passed" is fixed for Shopify
The bug with "QueryValidationError: Property PaymentMethodRef not found for Entity SalesReceipt" error is fixed for QuickBooks SalesReceipt
The bug with blank page for QuickBooks is fixed
The bug with "the module name given seems to be invalid" error is fixed for Zoho CRM
The bug with "Out of memory" error is fixed for all cloud providers
The bug with "'Type System.Collections.BitArray...' is not allowed here" error is fixed

2.5.502 20-Oct-20

Dynamics CRM objects 'relationship' and 'relationshipattribute' were removed from the list to fix the "The 'RetrieveMultiple' method does not support entities of type" error
The messages about subscription status in the Register Product dialog are supplemented with additional information
The bug with the "Unexpected SugarType 'widget'" error is fixed for SugarCRM
The bug with the "An item with the same key has already been added" error is fixed for SugarCRM
The bug with the "Oauth error missing_shopify_permission: read_all_orders" error was fixed for Shopify

2.5.441 23-Jul-20

SSH is supported in the Direct mode (Oracle)
SSL/TLS is supported in the Direct mode (Oracle)
License number is added to the Copy Info and About/Register windows
The ExchangeRate field is added to the Invoice object (QuickBooks)
The behavior is changed: now Import Data Wizard is opened and filters are restored in case the connection is not valid
The bug with the "Field 'Id' can not be sorted in a query call" error is fixed (Salesforce)

2.4.412 11-Jun-20

Web Login for Dynamics CRM is supported (Dynamics CRM)
A relation with Partitions through 'leadPartitionId' on Lead records is added for Marketo (Marketo)
The fields InventoryQuantity, OldInventoryQuantity and InventoryQuantityAdjustment from the object ProductVariants are made read-only according to updates in Shopify API (Shopify)
A bug with invisible 'UniqueExternalId' field in Freshdesk Contact object is fixed (Freshesk)

2.3.369 13-Apr-20

The new option "SQL Server command timeout" is added to Options -> Advanced
The bug with an error "Invalid column #0" for creating new columns manually for PostgreSQL is fixed (PostgreSQL)
The bug with reading the service_end_date column from the Products table is fixed (SugarCRM)
The bug with reading records with different values of ActivityTypeId from the Activities table is fixed (Marketo)
The bug with an error "Required fields are missing [ContactId]" that appeared for Salesforce Opportunity object during creation of a new entry is fixed (Salesforce)

2.3.314 24-Jan-20

QuickBooks OAuth 2.0 is supported
The parameter to select QuickBooks environment - Production or Sandbox - is added to the Connection Editor dialog box
The bug with disappearing row after update in Edit Mode for Zoho CRM is fixed

2.2.283 11-Dec-19

BigCommerce API v3 is supported
New Search API result limits implemented (Zendesk)

2.1.267 19-Nov-19

PostgreSQL 12 is supported
Web Login for HubSpot is supported
The Local SQL Engine advanced connection parameter, determining whether to run locally complex SQL statements that cannot be translated directly to corresponding cloud API calls or to display an error message, is added to Excel Add-ins for cloud applications
The Failover Retries advanced connection parameter, determining the number of attempts to re-run commands, failed because of a reason that may be temporary, before displaying an error message, is added to Excel Add-ins for cloud applications
The object LineItems is added (HubSpot)
The new authentication type ServerToServer is implemented (Salesforce Marketing Cloud)

2.0.187 25-July-19

The UseCustomLists parameter is added to NetSuite connections for enabling support of Custom List objects (NetSuite)
The web login feature now uses the operating system default browser for logging in to MailChimp (MailChimp)
The performance of starting Edit Mode with "Advanced edit mode" turned on is improved for cases when an Excel table was not created for the imported data
The performance of starting Edit Mode with "Advanced edit mode" turned off is improved
The behaviour is changed: InventoryStockItems is updatable now (Magento)
The bug when the user starts import for already imported data and selects another data source is fixed
The bug with not starting Edit Mode for an empty table is fixed
The bug with an error during editing when data were imported, but an Excel table for them was not created, is fixed
The bug with an error during editing when data were deleted after import, but an Excel table cannot be created, is fixed
The bug with duplicating an error message is fixed
The bug with not returning data for HubSpot Companies after update is fixed (HubSpot)
The bug with reading inactive related objects for Zoho CRM API v1 is fixed (Zoho CRM)
The bug with not reading the list of actual values of ticket types and using standard values instead is fixed (Freshdesk)

2.0.86 26-Feb-19

Displaying SQL commands for committing changes to Oracle is improved
The behaviour is changed: now, for data sources that support transactions, we allow starting Edit Mode if an imported table has at least one not read-only column and Use Transaction is enabled in options. However, depending on the data source and imported data, in some cases it can be impossible to submit the changes to the data source
The behaviour is changed: now an error is generated instead of committing when update or delete of a record actually affects more than one record
The behaviour is changed: now we start Edit Mode when the "Enum drop down list creation failed" error occurs instead of interrupting the start of Edit Mode after the error
The behaviour is changed: now the default browser is used for web login to Shopify instead of Internet Explorer
The bug with disabled Commit and Rollback buttons when the imported table has a formula referencing another Excel table after changes in this other table is fixed
The bug with deleting a record instead of marking it as deleted when the delete operation is not supported for a table is fixed
The bug with incorrect editing of the results of a query with table joins or a view with table joins when the joined tables have identity columns is fixed
The bug with the error of reading relation columns like 'Created By', 'Parent Account' etc. for Zoho CRM API v2, when Zoho CRM language is different from English, is fixed

2.0.62 17-Jan-19

PostgreSQL 11 is supported
The new option "Escape text values that start with '$' so Excel does not convert them" is added to Options -> Import -> Data -> Escaping
The possibility to edit data of user-defined SQL queries or views with a ROWID column is supported for Oracle database
The bug with committing changes for Oracle 12c table in the Direct mode when the Options -> Edit -> General -> "Refresh all columns after commit" check box is selected is fixed
The bug with incorrect fetching string data containing short date with only month and year is fixed
The bug of deletion of leading zero characters in a string value, storing a number, during import is fixed
The bug with data import, when the limit of records that can be stored in Excel worksheet is reached, is fixed

2.0.2 24-Oct-18

Microsoft Excel 2019 is supported
Freshdesk API v2 is supported
The default value of the "API Version" connection parameter for FreshBooks is changed from Classic to Alpha
The TicketDetails object with additional information about tickets is added for Freshdesk
The bug with login to Zoho CRM with API v2 is fixed
The bug when committing changes for a query, selecting the same field more then one time, back to Salesforce is fixed
The bug with not changing column order in a generated query after changing column order in Visual Query Builder is fixed

1.8.868 18-Sep-18

New FreshBooks API (alpha) is supported
The API v2 for Zoho CRM is supported
The PaymentPayouts object is added to Shopify
The default value for the "API Version" connection parameter for MailChimp is changed from v2 to v3
The bug with the "The given key was not present in the dictionary" error for Zoho CRM modules is fixed
The bug with not connecting to Dynamics CRM after the system update of Dynamics CRM on August 2018 is fixed
The bug with successful test connection for Zendesk when Email or API Token is not valid is fixed
The bug with limiting SQL query length is fixed
The bug with disabling the Next and Finish buttons in Import Data Wizard is fixed

1.7.797 30-May-18

The new "Keep hidden columns" check box for determining whether to show hidden columns when refreshing data is added to Refresh Options
The progress bar is added for starting Edit Mode
The speed of starting Edit Mode is greatly improved for large tables
The speed of the commit operation is greatly improved for large tables
The speed of a query with a LIMIT clause (with or without OFFSET) and without other not required clauses (like WHERE, ORDER BY, etc.) is greatly improved for Freshdesk (Freshdesk)
The speed of a query with a LIMIT clause and without other not required clauses (like WHERE, OFFSET, ORDER BY, etc.) is greatly improved for Salesforce Marketing Cloud (Salesforce Marketing Cloud)
The behaviour is changed: now if a multicolumn unique or primary index is violated, you can change a value in any of the index columns in order to fix the uniqueness violation
The behaviour is changed: now hidden columns are not unhidden after refresh by default
Several bugs when moving an imported table and then adding or removing rows above or below the imported table during Edit Mode are fixed
The bug with throwing the "Value for column is required. " error instead of a unique index violation when entering duplicate values for a multicolumn unique or primary index is fixed
The bug with not counting changes in a cell by Excel formulas as changed values in Edit Mode is fixed
The bug with freezing after canceling a refresh operation is fixed
The bug with presence of not valid values in a picklist is fixed
The bug with previewing rows before finishing data import when the number of columns is greater than 655 is fixed
The bug with the "Exception has been thrown by the target of an invocation" error for the HubSpot source is fixed (HubSpot)
The bug with inability to install Excel Add-ins only for Freshdesk or Zendesk is fixed (Freshdesk, Zendesk)
The bug with starting Edit Mode for the read-only InventoryStockItems table for Magento 2 is fixed (Magento)
The bug for the MySQL source with creating a new row with an empty value for auto-increment columns in the Edit Mode is fixed (MySQL)

1.7.748 19-Mar-18

Data refresh is significantly improved:

Refresh now preserves user's data on the same worksheet outside of the table with imported data
Data sorting in the table with imported data is now preserved if Keep table if exists and Keep table sorting check boxes are selected in Refresh Options
Table style the table with imported data is now preserved if Keep table if exists check box is selected in Refresh Options
Excel Add-ins now display the progress of Refresh and Refresh All operations and allow canceling them
Refresh Options are added:

Confirm 'Refresh' action - determines whether to display the confirmation dialog box when refreshing data on the current worksheet
Confirm 'Refresh All' action - determines whether to display the confirmation dialog box when refreshing data on all the worksheets
Keep table if exists - determines whether to re-create an Excel table with imported data or to keep an existing one when refreshing data
Keep table sorting - Determines whether to keep sorting settings in an Excel table with imported data when refreshing data

Refresh now preserves references to imported table cells in Excel formulas if there is no user data under the table with imported data
The behaviour is changed: now Refresh is not allowed if there is a user's table below the table with imported data
The behaviour is changed: now Refresh preserves the number of empty rows between the table with imported data and user's data below it

Edit Mode is greatly improved:

Edit Mode now allows using AutoFill using the fill handle
Edit Mode now allows using formulas, scripts, comments, etc.
Edit Mode now allows editing data on the same worksheet outside of the table with imported data
Edit Mode now allows copying/pasting data from the same workbook with the table with imported data
Edit Mode now allows copying/pasting of multiple rows
Edit Mode now allows and preserves sorting and filtering (AutoFilter) of the table with imported data
Edit Mode now preserves comments for the cells of the table with imported data
Edit Mode now allows and preserves hiding and unhiding columns
For cloud sources, if a field accepts only a value from a fixed list of allowed values, Devart Excel Add-ins support selecting a value from a drop-down list of allowed values both when editing a cell and in table filters
Optional underlining is now used instead of the popup comments when inserting a new row and moving focus out of it without filling all the required columns
The Advanced edit mode check box (selected by default) is added to the Edit - General options for reverting back to pre-1.7 Edit Mode
Options for selecting underlining color for cells of a new row are added
Excel Add-ins now check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value when the "Validate required (not null without default value) columns for RDBMS" check box is selected in the Edit - General options

Excel Add-ins now display the progress of committing changes to the data source
The table with the imported data now can be moved to any place on the worksheet, and after this can be correctly refreshed or edited in the Edit Mode
Windows scaling for high-DPI devices is supported
The RegionId field is added to CustomerAddresses for Magento 2 (Magento)
The Magento connection editor is improved for Ver2 servers (Magento)
The "Use Custom Fields" parameter is added to Zendesk connections to determine whether to read custom fields for Ticket, Request, View, User, Organization objects (Zendesk)
The possibility to connect to Salesforce Sandbox is implemented (Salesforce)
INSERT and UPDATE operations support for AccountUser in Salesforce Marketing Cloud is added (Salesforce Marketing Cloud)
The behaviour is changed: now date values for filters are generated with the time 00:00 by default. This behaviour can be changed with the Options > Import > Filter > "DateTime picker editor default value" option
Now Excel Add-ins do not try to load more then 65536 records for the Excel 97-2003 file format and more than 16384 records for the Excel 5.0 and Excel 95 file format and display the corresponding warning message
The bug with corrupting unicode characters for the SQL Server source is fixed (SQL Server)
The bug for the SQL Server source with not starting Edit Mode when primary key columns of a table are not imported, but a unique column is imported is fixed (SQL Server)
The bug with processing records with GUID in SQLite when the edit mode is on is fixed (SQLite)
The bug for the PostgreSQL source with not starting Edit Mode when a base table is imported with related table columns is fixed (PostgreSQL)
The bug for the MySQL source with not starting Edit Mode when a base table is imported with related table columns is fixed (MySQL)

1.6.623 13-Sep-17

Shared workbooks are supported
The speed of data import is greatly improved
The "Use Display Name For Custom Tables" parameter is added to Zoho CRM connection for showing a display name instead of a module name for custom modules (Zoho CRM)
The Sandbox check box is added to the NetSuite connection editor (NetSuite)
The ListMemberInterests view is added for showing which subscriber belongs to which group (MailChimp)
The LineItems JSON field is added to the Shopify Fulfillments object (Shopify)
The behaviour is changed: now insert and update operations are available for the Shopify Fulfillments object (Shopify)
The possibility to select a Zoho CRM connection domain in the connection editor is added (Zoho CRM)
The UniqueExternalId field is added to the Freshdesk User object (Freshdesk)
The bug with importing not all HubSpot Deals is fixed (HubSpot)
The bug with the error when inserting a new Freshdesk ticket and specifying values not only for the RequesterId column is fixed (Freshdesk)
The bug with the error when a Freshdesk object has a custom field with the same name as one of the default fields is fixed (Freshdesk)

1.6.547 18-May-17

The bug with retrieving object metadata when there is a field of the ulong type is fixed (SugarCRM)
The bug with requiring invalid values for the CurrencyIsoCode column for Salesforce is fixed (Salesforce)

1.6.506 22-Mar-17

The bug with moving modal windows outside of the screen when changing screen settings or switching to another monitor in multimonitor configurations is fixed
The bug with test connection always successful even with invalid credentials in the advanced connection editor for Salesforce Marketing Cloud, NetSuite and Zoho CRM sources is fixed
The bug with the trial expired for a HubSpot source after the first installation is fixed (HubSpot)
The bug with querying Quotes object with JOIN is fixed (Zoho CRM)

1.6.469 27-Jan-17

Freshdesk is now supported
G Suite is now supported
HubSpot is now supported
Marketo is now supported
NetSuite is now supported
Shopify is now supported
Zendesk is now supported
The new option "Read-only primary key columns for the existing (committed) records" is added to Options > Edit > General
The bug with not displaying modal windows like Import Data Wizard or Connection editor is fixed
The bug with not changing the "Refresh all columns after commit" option is fixed
The bug with PostGIS datatypes is fixed (PostgreSQL)

1.5.319 23-Jun-16

TLS 1.1 is supported
Field validation for cases when values must be unique or NULL is implemented
The new option "Escape text values that end with '%' so Excel does not treat them as percentage" is added to Options -> Import -> Data -> Escaping
The new option "Escape text values that contain special chars so Excel does not treat them as datetime" is added to Options -> Import -> Data -> Escaping
A new required column "Item" is added to the OrderShipments table for BigCommerce (BigCommerce)
The "is null" and "is not null" filter operators for mandatory fields in Zoho CRM is added (Zoho CRM)
The speed of processing of modifying a large number of cells at once when the edit mode is on is greatly improved
The behaviour is changed: now the default value for the 'Unicode' parameter of the connection to a PostgreSQL database is True (PostgreSQL)
The bug with determining added/deleted records, when there are some user data in the cell to the right of the imported table, is fixed
The bug with deleting user data outside of the edited table when deleting records from the edited table is fixed
The bug with unreadable cell comments, showing validation errors of enum values, in case of enums with a large number of elements is fixed
The bug with not saving changes made on the Import -> Data tab of the Options dialog box is fixed
The bug with deleting a row when there are some user data in cells to the right of the imported table is fixed
The bug with connecting to a PostgreSQL database via SSL is fixed (PostgreSQL)
The bug with 100 records limitation when selecting data from the ABTestingCampaigns table is fixed (MailChimp)
The bug with SQL generation when editing tables via linked server is fixed (SQL Server)
The bug when a mandatory field has a null value and both where and order by clauses are used in Zoho CRM, is fixed (Zoho CRM)

1.5.239 18-Feb-16

The bug with trial expired after installation Excel Add-in for Magento and Excel Add-in for ExactTarget is fixed

1.5.234 11-Feb-16

Excel 2016 is supported
Magento is now supported
ExactTarget is now supported
Web Login for Salesforce is supported
The ABTestingCampaigns table for getting Campaigns with the A/B testing type is added for MailChimp (MailChimp)
A progress indicator for execution of a query for data preview in Import Data Wizard with the possibility to cancel the operation has been added
The implementation of refresh is improved: now data in Excel worksheet columns not belonging to an imported table is not deleted after refreshing
The bug with "Microsoft Office Excel is waiting for another application to complete an OLE action" while executing a query from Import Data Wizard has been fixed
The bug when trying to refresh records from a Greenplum database after an INSERT/UPDATE operation is fixed
The bug with successful connection to an invalid host after establishing a valid connection for CRM sources is fixed
The bug with the Help button disabled in Excel 64-bit is fixed
The bug with incorrect import of string or number values which can be interpreted by Excel as dates has been fixed
The bug with loosing columns in the result set when importing data from Zoho is fixed (Zoho)

1.2.130 03-Sept-15

The MergeFieldsDetectionBehavior connection string parameter is implemented for MailChimp to determine which merge tags to add to the ListMembers table
Validation of entered unsigned number values is implemented
Validation of entered enum field values for all supported cloud sources is implemented
The bug with incorrect displaying of validation error hints for two nearby cells is fixed
The bug with not available Excel Add-ins for other Windows users for Excel 64-bit is fixed
The bug with connecting to QuickBooks via Web Login is fixed
The bug with incorrect behaviour of Excel Add-ins installation when installing a newer version over an older one has been fixed

1.2.126 26-Aug-15

FreshBooks is now supported
Bigcommerce is now supported
The new option "Refresh all columns after commit" with default value true for refreshing data after commit is added to Options -> Edit -> General
The new option "Read-only cells of new row" for changing color for read-only cells in a new row is added to Options -> Edit -> Appearance
The new option "Show commit error message" is added to Options -> Edit -> Error Handling
The performance of importing data to Excel was significantly improved with memory use optimizations
The bug with the "Object reference not set to an instance of an object" error during execution of SQL operations which do not return result set is fixed
The bug with committing data that was rolled back earlier in the current Edit Mode session during the Commit operation is fixed
The bug with identity primary key column when editing data for SQL Server is fixed
The bug with opening Import Data Wizard when executing Refresh or Edit Mode for SQL Server database with Windows Authentication is fixed
The bug with not refreshing data if an Edit data session was not finished correctly is fixed
The bug with freezing when importing a large number of rows is fixed
The bug with calling Cancel during data import is fixed

1.1.83 18-Jun-15

QuickBooks is now supported
MailChimp is now supported
The bug with freezing when importing data to Excel 2007 is fixed
The bug with quoting database names for SQL Server is fixed

1.00.62 20-May-15

The bug with import from SQL Server using a query, where table names are specified without the database or schema name, is fixed
The bug with import from SQL Server using a query with expressions, functions, or literals is fixed
The bug with column duplication when importing views from SQL Server is fixed
The bug with the "Sequence contains no elements" exception when importing data is fixed

1.00.44 17-Apr-15

First release of Excel Add-ins