on 05-21-2008 2:13 PM
Hello Forum and Analyzer Experts,
I need your help very much to set one filter values for multiple dataproviders in one workbook with one dataprovider on each worksheet.
The characteristic contains an hierarchy with > 100 items. This is the reason we can't use the DropDown-Item. With this item, we can choose influenced dataproviders.
Our aim is to do this with navigation panes.
I've tried to start setting filters by button with a corresponding command area. This button was "clicked" in my refresh sub, what results and endless loop.
Has anyone an idea to set the filter settings? Points will be assigned.
Regards,
Tobias
We met the requirements by providing a vb button to set the filter global. Therefore we get the source where the button was clicked, read the filter value on this sheet and set this value to the command area used for setting this value to all dps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.