I am currently struggling with an issue with Excel Web Servces and pivot tables. We have several site collections in which we expose pivot tables with filters through EWA web parts. The issue is that the filters that are usedin pivot tables don't execute and return nothing. You click on the filter and it just spins. Here is where it gets odd. There is a site collection on the same farm where the same reports work fine. I have compared many settings and at this point comparing apples to apples between the collection.
Unfortunately I don't have back end access so it would be tough to take a look at Central Administration.
What other options do I have at this point? This has been escalated to our infrastructure team and they have since involved Microsoft. I am just concerned that I am missing something obvious.
One thing I will add is that upon creating a new report center site the sample dashboard that is created also exhibits the same behavior. The pivot filters wont work.