on 09-13-2010 3:46 PM
Hi all,
I have a custom menu with a step that should open an input schedule.
Therefore I added a OPENWEBFILE action in the EV_DEFAULT sheet.
The path linked to this step should change according to a dimension of the current view.
For instance,
-if DIMENSION=XX, the path should be INPUTSCHEDULES/XX/filename.xlt
-if DIMENSION=YY, the path should be INPUTSCHEDULES/YY/filename.xlt
I found a way to do it, but the formula is not refreshing when I change the current view, and the custom menu always open the same input schedule. The only way to refresh it is to go back to the EV_DEFAULT sheet and click on ETools, CustomMenuManager, Test Current Worksheet: this is something that a user is not allowed to do.
Do you have any idea about this? What could be a possible solution? Maybe a macro with an EV formula that refreshes the custom menu?
Thanks for your help
Please enable the custom menu in BPC administration console and use the Open Custom Menu option in BPC for Excel to open the appropriate custom menu. Please check here whether the custom menu is refreshed or not. Test Current Worksheet is supposed to simulate this and test the custom menu before enabling it in the BPC administration consol.
Custom menus already have macro functions included in it. Please try to utilise those macros when necessary, instead of building new ones.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot: that's what I did and it works now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.