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.