Macro MNU_ETOOLS_EXPAND doesn't work while menu command EVDRE: Expand and Refresh does

[former_member577658]

Hello,

I'm confused by the strange behavior of an excel report (75NW) when using different expansion options.

Say, I change one of row expansions, like BAS(Acc1) for BAS(Acc2). The set of rows obviously has to change when applying any of 'Expand' commands'.

However, Planning and Consolidation => eTools => Expand All, and button executing macro Application.Run("MNU_ETOOLS_EXPAND") or MNU_ETOOLS_EXPANDAND REFRESH produce no effect whatsoever.

Only context menu (mouse-right-click) command EVDRE: Expand and Refresh (both 'Active Sheet' and 'Active Workbook' options) allow to the report to perform row expansion. However, I need the expansion to be executed by button/macro, not menu commands, so I need to find a way to make button/macro work.

Anyone had ever seen such a strange behavior of EVDRE expansions?

Please help,

Valery

[former_member186498]

Hi Valery,

are Acc1 and Acc2 parent accounts?

Kind regards

     Roberto

[former_member577658]

Yes, Roberto,

Acc1 and Acc2 are definitely parent accounts.

[former_member186498]

Hi Valery,

please see http://service.sap.com/sap/support/notes/1702517 maybe it helps.

Kind regards

     Roberto