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

A

Avi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Web Service - Multiple Pivot Charts - How to Have One commonFilter 0
Change report firlds in pivot tables and charts with one selection 0
Embed the same Excel multiple times 0
Pivot Table Custom Filters 0
Excel 2013 Copying pivot charts to PowerPoint 0
Move some sheets to a new workbook, without macros, and withoutbreaking link btwn Pivot Tables and P 0
Pivot Tables/Charts and common filter 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13

Top