Analysis for Office template inserting new Structure Element in wrong order

[TammyPowlas]

Many of our users have a locally saved Analysis for Office template based on one of our BEX queries. This query contains a custom fiscal year structure that we update annually with the new year.

When the user tries to modify their template to include the new year, it adds it as the rightmost column, even though it should appear as the leftmost column.

Before

After

When opening the query the normal way (no template), the columns are in the correct order.

We'd prefer to not recreate the templates, since there are many of them across several local machines.

Any advice would be much appreciated.

[TammyPowlas]

Hi Ben - which version of Analysis Office are you using?

[TammyPowlas]

Not sure if it will help, but this SAP Note https://launchpad.support.sap.com/#/notes/2524722 refers to some links that "may" help https://support.office.com/en-us/article/Automatically-open-a-specific-workbook-or-template-when-you...

[ben_yardenay]

Thanks Tammy. Unfortunately this doesn't address our issue.