Hi,

not sure if my title makes sense, but I have a spreadsheet that has multiple
pivot tables accessing the same cube. I want to apply the same filter to all
pivot tables, preferably from a cell on a different worksheet.

I am realitvely inexperienced with Excel, but do not seem to be able to find
a reference to this functionality on the web. It may be that I am asking the
wrong questions.

The version of Excel is 2007 and I am connecting to SQL 2008 Analysis
services.
Any help would be much appreciated.

thanks Jason