Excel Web Service - Multiple Pivot Charts - How to Have One commonFilter
 

Excel Web Service - Multiple Pivot Charts - How to Have One common
Filter
Hi,

I have an Excel2007 dashboard, which contains more than 5 pivot
charts. Its a testing dashboard, which has got several defect metrics
based on same data source. I am publishing these pivot charts to
Sharepoint using excel web service.

Currently I need to fiter all pivots one by one to see the charts for
different parameter. something like (if I need to select the defects
for different releases, i select them one by one in all pivots). I
know, i can create a simple macro to trigger updates to all pivots.

But the problem I am facing is - After I publish the pivot charts to
Sharepoint. Macros will disabled (not supported in Shoarepoint 2007).

So, please suggest me if there is any workaround possible to create a
common filter on Sharepoint that will refresh all the pivots.

Thanks,
Avinash