Today I would like to share another mini tip about Business Central, how to switch environments and companies directly in the Edit in Excel file.
Tag Archives: excel
7 Excel Tips For Business Central
Excel is one of the most used tools worldwide. In this post, you will learn 7 tips to export data from Business Central to Microsoft Excel. Also, you will learn how to connect OData Feed and Power Automate to Business Central.
D365 Business Central : Using Excel Layout for Reporting
Since Business Central 2022 Wave 1 (BC20), we have the ability to use Excel Layout for reporting. Excel layouts work the same way as Word and RDLC layouts in that they can be edited and saved back again into Business Central. With Excel layouts for Business Central reports, users can now create and edit report layouts simply by using the full capabilities in Excel such as sliders, diagrams, charts, and pivot tables. Let’s try to create one using Inventory Order Details.
Excel Reports – something new in reporting space
Last week I have been exploring the Excel Layouts which are a brand new feature in Business Central version 20 (Wave 1 2022). I did not only watch the video from the Launching Event, but I also developed one of the reports. If you want to know what I think of it check below.
Dynamics 365 Business Central: How to disable “Edit in Excel” on a specific page
With pages in Business Central that display a list of records in rows and columns, like a list of items, sale orders, or invoices, you can export the list to Microsoft Excel, and view it there. Depending on the page, you have two options for viewing in Excel.
Dynamics 365 Business Central 2022 Wave 1: introducing Excel Layouts for reporting
How many times in real world projects a customer asked you to create custom exports in Excel in order to fill a pre-defined and pre-formatted Excel report (with formulas, charts, macros and more) or to create an Excel report exactly like in a given model? Personally, I’ve lost the count…
Now with the new Excel Layout feature, this is possible directly at customer’s fingertips.
Dynamics 365 Business Central: How to add Edit in Excel to Card and Document Pages (codeunit 1481 “Edit in Excel”)
Today I would like to talk about how to add Edit in Excel feature to Card and Document Pages in Business Central.
As you might know, the Edit in Excel action is available on most lists, but not all.