Delegated admins can edit in Excel

Important

This content is archived and is not being updated. For the latest documentation, go to What's 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
Admins, makers, marketers, or analysts, automatically Sep 1, 2022 Oct 1, 2022

Business value

Customers often delegate support and administration to their supporting partner. When these delegated administrators need to bulk correct or insert data, Excel is the tool of choice. The add-in now empowers admins to refresh and publish to Business Central, making this a powerful tool for data manipulation.

Feature details

Delegated administrators can now use the Excel add-in like any other user in the customer's Azure Active Directory organization. The Edit in Excel system action in the client opens the add-in, but admins can also create new datasets in Excel directly. Use this to provide bulk data support, such as correcting data entry mistakes, importing tables from legacy systems, and making data adjustments that cannot be done via data upgrade scripts.

Watch the video

Check out the 15-minute video where the product engineering team at Microsoft presents this feature and other enhancements that keep you productive with Microsoft 365.

To access recordings on demand from the Business Central 2022 release wave 2 launch event, register for free at aka.ms/BCLE.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

See also

Delegated Administrator Access to Business Central Online (docs)