Share via

Use built-in named formulas in Excel layouts

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

Business value

Built-in named formulas save Excel report authors time and effort by making it easy to get data from metadata sheets.

Feature details

To make it easier to use data from metadata sheets, Excel layout workbooks include named formulas when you generate them in the 2024 release wave 2. Instead of spending time creating complex VLOOKUP or XLOOKUP formulas, report authors can use named formulas such as ReportRequest.Date or ReportMetaData.ReportHelpLink.

Named formulas included in Excel layout workbooks

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Additional resources

Creating an Excel layout report (docs)