This function retrieves information about published reports on the web. In the Excel edition it is a placeholder. 

Syntax

XL3ReportInfo(ItemName)

Parameters

ParameterDescription
ItemName

Text, the name of the report property to retrieve. Valid values are:

  • ReportName
  • LastPublished
  • Description
  • PublishedBy
  • Path 
  • webserver 

When you build a report in Anaplan XL Excel edition, cells containing =XL3ReportInfo() formulas serve as placeholders. When you publish the report to your web server, those formulas automatically populate with the correct web server details, timestamps, and publisher information.

Example

You can use the listed parameters to build a report. 

ParameterFormula usedRendered output example
ReportName=XL3ReportInfo("ReportName")Q1_Global_Consolidation_v2
LastPublished=XL3ReportInfo("LastPublished")2026-05-06 09:15 AM
Description=XL3ReportInfo("Description")Q1 2026 roll-up for all global entities
PublishedBy=XL3ReportInfo("PublishedBy")finance_admin
Path=XL3ReportInfo("Path")/Finance/Quarterly_Reports/2026/
webserver=XL3ReportInfo("webserver")reporting.company.internal