Skip to Content
Aug 06, 2012 at 02:11 PM

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



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,