Use built-in named formulas in Excel layouts

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for	Public preview	General availability
Admins, makers, marketers, or analysts, automatically	-	Oct 1, 2024

Business value

We're saving Excel report authors time and energy by providing built-in named formulas that make it easy to access data from metadata sheets.

Feature details

To make it easier to use data from metadata sheets, named formulas are now built in to Excel layout workbooks (when generated in 2024 release wave 2). Instead of taking time to develop complicated VLOOKUP or XLOOKUP formulas, report authors can use named formulas, such as ReportRequest.Date or ReportMetaData.ReportHelpLink.

Additional resources

Creating an Excel layout report (docs)