Excel Add-Ins V1.7 From Devart

Devart s.r.o has released version 1.7 of his Excel Add-ins that allow connecting Excel to cloud and database data, edit this data, and save it back to the data source.

The update offers improvements like advanced Edit Mode, refined data Refresh options and new cloud app add-ins.

Update allows more convenient and flexible editing and refreshing cloud and database data, including:

Advanced Edit Mode that eliminates a lot of previous limitations. Now a user can freely:

- - Copy and paste data in the Edit Mode, including pasting multiple rows, and copying data in the same workbook and worksheet with the imported table

- - Use many Excel editing features, like formulas, scripts, Autofill, etc.
  - Sort and filter of the table with imported data, hiding and unhiding columns, allows editing data outside of the imported table on the same worksheet, etc.
  - …and more.

Refresh Improvements that preserve user’s data, entered outside of the table with imported data on the same worksheet, data sorting settings in this table and table styles. Moreover, the Refresh options allow users:
- - See the refresh operation progress and cancel it if necessary
  - Disable confirmation dialog boxes when starting refresh

Other Improvements that include following handy features:

Excel Add-in for Zendesk has supported custom fields for certain Zendesk objects
Excel Add-in for Magento offers a more convenient connection editor for connecting to Magento 2 servers
Excel Add-in for Salesforce now allows connecting to Salesforce Sandbox

The company’s Excel add-ins support Windows scaling for high-DPI devices and display progress of commit changes operations.