Use built-in named formulas in Excel layouts
Important
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, marketers, or analysts, automatically | - | Oct 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.
