With a Grid report open, right-click over the grid and select Anaplan XL > Properties. Select the XML tab to modify the XML options for a Grid.
| Option | Description |
| Connection | Set the connection for the Grid |
| Auto-generate MDX (default) | Anaplan XL controls the MDX for the Grid, given the selected options, hierarchies and members. |
| Manual MDX | You may type your own MDX in the edit field. Using XL3Parm( Address ) allows you to substitute parts of the MDX with cells on the worksheet. |
| Get MDX from Excel range | The entire MDX statement for the Grid is taken from a cell on the worksheet. |
