Editing in Excel more reliably

Important

This content is archived and is not being updated. For the latest documentation, go to New and Planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for	Public preview	General availability
Users, automatically	-	Apr 22, 2021

Business value

Many business processes rely on Microsoft Excel for data entry, bulk editing, or simply for data analysis. We're improving the reliability of the Excel add-in so that business users can work more effectively in a broader range of scenarios.

Feature details

Support for company names with international characters

Add the Business Central Excel add-in to your Excel spreadsheet, and enjoy how you can edit or refresh data from Business Central companies. Now you can also get and update data from Business Central companies where the company name includes non-English characters or non-letter symbols.

This improvement is available from April 22, 2021 when you connect Excel to any of the supported versions of Business Central.

Better handling of Flow Fields

In earlier versions of Business Central, you would often run into problems when you edited multiple rows in a list in Excel when the list included FlowFields. This was typically due to the FlowField being recalculated, which caused problems in determining if there are conflicting changes to a record. With this update, we've greatly reduced the risk of error due to FlowField calculations on one row being affected by changes to another row.