Pivot table Filter event

**haissk** · 08-13-2009, 03:14 AM

Hi Experts,

I want to call some function only when the pivot table page item filter is selected and not on row item filter. please let me know how to do that

thanks
Sathish

**DonkeyOte** · 08-13-2009, 04:50 AM

You could possibly use the Worksheet Change event on the sheet containing the PT to test to see if Target altered is within the PivotTable's Page Range, eg:

Please Login or Register  to view this content.

**jeffreyweir** · 07-10-2014, 08:45 AM

I've just written a series of posts on how to do this:
http://dailydoseofexcel.com/archives...date-part-one/
http://dailydoseofexcel.com/archives...date-part-two/
http://dailydoseofexcel.com/archives...ate-part-tres/
http://dailydoseofexcel.com/archives...te-episode-iv/

Pivot table Filter event

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table Filter event

Re: Pivot table Filter event

Re: Pivot table Filter event

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions