Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-23 Thread ashish koul
can you email you file to excel-macros@googlegroups.com and attach the workbook On Mon, May 23, 2011 at 9:58 PM, Robert Jacobs wrote: > Well after a bit of searching, it's looking like the Report > filters are not dependent. No matter what you select in one report > filter, every record

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-23 Thread Robert Jacobs
Well after a bit of searching, it's looking like the Report filters are not dependent. No matter what you select in one report filter, every record is still listed in the other filters, even if they won't show any data when selected. Apparently there's no real way to do this, other than upgra

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-23 Thread Robert Jacobs
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 j

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-20 Thread ashish koul
can you attach the sample file On Sat, May 21, 2011 at 1:31 AM, Robert Jacobs 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 wo

$$Excel-Macros$$ Update pivot table filters based on already applied filters?

2011-05-20 Thread Robert Jacobs
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