Excel and PowerPoint Add-ins: Line Item reordering
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. It is present on
Issue When creating a connection to a module that uses parents in Line Items, the Anaplan Add-ins may re-order the output so that it is different to how it is shown in Anaplan on the web. Note that this only applies to connections that are to the module itself, rather than a saved view.
Workaround Creating a saved view or using the view titled 'default view' forces the correct order.
Note: Saved views cannot be pivoted from within the Add-in and would have to be updated from within Anaplan. Creating a saved view adds a row to the connection details at the top of the worksheet so the data will be shifted down 1 row compared to the original page. This is only an issue if you have external cell references which will need to be manually adjusted to reflect this.
If this workaround is not suitable in your use case, please contact Support at firstname.lastname@example.org.