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)