New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

November 11, 2021

Excel Enhancements for Business Central (update version 19)

With the release of Business Central version 19, Microsoft has made changes to the commonly used “Open in Excel” and “Edit in Excel” Options. Now, there is a new Share icon that has been added to the top right of the pages where you can now find these options.

This option has also been added to list pages that are embedded to pages like the sales lines on a sales order.

In addition to the new icon, there were also other enhancements included with the new release which include:

  • Captions in the excel file have now been updated to match the captions within the Business Central client in the user’s current language.
  • The names of the files exported when using Open in Excel or Edit in Excel have been updated to match the name of the page.
  • In the Excel Add-in, the error messages have been improved to provide more details to help troubleshoot issues.

 

 

Share On: 

Other articles

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…

How to Tell if Your Distribution Business Has Outgrown Its Systems

Jennifer Ryan

|

December 1, 2025
As a former Controller inside a fast-moving distribution business, I learned this lesson the hard way: You don’t realize your system is breaking until growth exposes every weakness.It doesn’t happen…

Why Microsoft Killed Social Posting (And Why SMBs Should Care)

Jackie Gant

|

November 25, 2025
When Microsoft quietly pulled the plug on social posting in Dynamics 365 Customer Insights late last year, few in the small to mid-sized business (SMB) space raised an eyebrow. After…