Important
The planned features for this release wave have been updated and this feature appears to have been removed.
This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.
The first of the new functionality in the Productive with Microsoft 365 section is enhancements to Excel add-in.
Bulk editing, co-authoring, and analysing data in Excel are common tasks for many back-office users. Microsoft say their research shows that workers often rely on Excel for mission-critical activities and therefore expect a high degree of reliability as they edit in Excel, refresh data, and push changes back to Business Central. In this wave, Microsoft address feedback about the reliability of the add-in in specific use cases.
Enabled for: Users, automatically
Public Preview: Sep 2023
General Availability: Oct 2023
Feature Details
This release wave includes the following enhancements to the Business Central add-in for Excel:
- Dimensions are included on more pages when using the Edit in Excel feature.
- Increased accuracy of filters when they’re transferred from Business Central to Excel.
- Improved reliability and performance of data refresh and publish through the latest OData V4 technology.
- The add-in now supports on-premises deployments that have a dedicated server instance specifically for OData feeds.
My Opinion
Making dimensions available in more pages sounds like a good addition, as everyone I’ve worked with using Business Central uses dimensions. Improved reliability and accuracy also sounds like a really good thing.