Since upgrading to BC V18, has anyone noticed that Open in Excel is gone on any List Part page?
For example, Sales Order Subform:
Items by Location page:
Information from Microsoft Yammer:
Microsoft has removed the option to Open in Excel on ListPlus pages.
In many cases, “Open in Excel” on a ListPlus Page was outputing the wrong data or data from the wrong table. With BC18, we’ve removed the option to Open in Excel on ListPlus pages.
And fortunately, the information was updated on June 18. Microsoft will bring it back to Update 18.3. 👏👏👏
This week, update 18.3 for Microsoft Dynamics 365 Business Central 2021 Release Wave 1 was available.
For more details: Cumulative Update Summary for Microsoft Dynamics 365 Business Central（July, 2021）
And Open in Excel | MS Docs has also been updated.
Starting with update 18.3, you can also view lists that are shown in page parts, like the lines in a sales order. For now, this capability is an optional feature, which requires that you enable Export any list part to Excel in Feature Management. For more information, see Enabling Upcoming Features Ahead of Time.
Let’s try it.
Choose the Tell Me icon, enter Feature Management, and then choose the related link.
Now you can find a new feature, Feature: Export any list part to Excel.
Change Enabled for to All Users.
Then sign out and sign in again to make the changes take effect.
You can find Open in Excel in Manage group. (Not in Page group)
Hope this will help.
Thanks for reading.