I access this from Google Groups... don't see an attach option. Email possibly?
I have found the PivotTableSelectionChange() event, I just don't know what to add here. I've tried the refresh pivot table code, but it doesn't refresh the selection list. Again, my data's not actually changing, I just want the options in the selection lists for each filter (they are all report filters) to reflect filters already applied. For instance, if I filter by sales territory, I would like the customer name filter to only include names for the sales territory selected. It shows all names now - if I click on a customer name that doesn't belong to the currently selected sales territory, it just shows a blank chart. Help is appreciated!!!! Thanks! On May 20, 11:37 pm, ashish koul <koul.ash...@gmail.com> wrote: > can you attach the sample file > > On Sat, May 21, 2011 at 1:31 AM, Robert Jacobs > <robertjacob...@gmail.com>wrote: > > > > > > > > > > > Thank you in advance, experts!!!!! (also posted on Microsoft Excel > > group, but not as many members, nor as many responses as I see here) > > > I have an Excel file with a couple of pivot tables. Everything works > > perfectly, but I would like one more piece of functionality, if it's > > possible. > > My raw data includes 6 columns, which are Cust#, CustName, SalesRep, > > InvAmount, InvDate, and CustCategory. When I go to my pivot table, I > > have it setup like: > > Report Filters: Cust#, CustName, SalesRep, CustCategory > > Row Labels: InvDate > > Values: Sum of InvAmount > > When I apply a filter, such as I display all information regarding > > the > > SalesRep, the filter works perfectly, showing me only InvDates and > > InvAmount sums for that SalesRep. BUT, when I want to apply a second > > filter, the filter list itself still contains all Cust#, CustName, > > and > > CustCategory options for all sales reps. Is it possible to filter > > the > > list once a filter has been applied, so if I filter down to a single > > SalesRep, I only see his/her accounts listed in the other filter > > lists? > > Man, that was hard to word, and I still don't know if I got it > > right... PLEASE HELP if possible!!! Thanks guys!!!!!!!! > > > -- > > > --------------------------------------------------------------------------- > > ------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
