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?