Anaplan XL Reporting enables you to create named ranges based on parts of the grid or table. This simplifies many interactions between Excel and Anaplan XL, such as formulas or charts based on Anaplan XL ranges.
You can access this feature on the Grid Properties or Table Properties form, on the Interaction tab. From here, you can see and edit existing ranges or set up new ones.
Named range properties for grids
| Name | Description |
| Name | The name to give the named range. This is used to refer to the range in formulas and the chart dialogs. |
| Scope | Where the named range is recognized — either all over the workbook, or tied to the Grid worksheet, for example, Sheet1!MyRange. |
| Whole Grid - Members and data | The named range covers all members and data in the entire grid. |
| Whole Grid - Data | The named range covers all the data in the grid. |
| Members - Axis | The named range covers the members on the specified axis. |
| Members - Hierarchy | The named range covers the members belonging to the specified hierarchy. |
| Slice - Members and data | The named range covers the members and data belonging to the specified slice. |
| Slice - Members | The named range covers the members belonging to the specified slice. |
| Slice - Data | The named range covers the data belonging to the specified slice. |
Named range properties for tables
| Name | Description |
| Name | The name to give the named range. This is used to refer to the range in formulas and the chart dialogs. |
| Scope | Where the named range is recognized — either all over the workbook or tied to the table worksheet, for example, Sheet1!MyRange. |
| Table - Headers and data | The named range covers all headers and data in the entire table. |
| Table - Headers | The named range covers all headers in the entire table. |
| Table - Data | The named range covers all the data in the table. |
| Table - Last Data Cell | The named range follows the bottom/right data cell. Helpful as part of a range specification, for example, A1:LastDataCell. |
| Columns - Headers and data | The named range covers the headers and data belonging to the specified column. |
| Columns - Headers | The named range covers the headers belonging to the specified column. |
| Columns - Data | The named range covers the data belonging to the specified column. |
