OLAP filters from cells


J

Jason

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
 
Ad

Advertisements

B

Bob Phillips

Will all of the pivot have the same filter built in and you just want to set
it via code?

If so, try something like

With Activesheet

.PivotTables("PivotTable2").PageFields(1).CurrentPageName =
Range("A1").Value
End With
 
Ad

Advertisements

J

Jason

thanks for the response. You have answered my question in that I need to
write some VBA. My current knowledge of Excel ends when we drop in to VBA.
However with your input I will go away and learn what I need to put your
answer in to practise.

Once again thanks for your help

Jason
 

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

Top