SelectionChange and Pivot Tables

[andym]

Dear All,

my testing to date doesn't show that a change in pivot table criteria
fields triggers a SelectionChange event.

As I get a "too many records to complete" error message when I try and
add a Calculated Item, I am attempting to add an additional column to
the right of the pivot table which does my calculation for me.

Basically I want to do the following:
1.Select Pivot Field criteria
2. Trigger SelectionChange
3. Run some code that calculates the number of rows returned in the
pivot table, then add some formulas to the right hand side of the pivot
based upon data in the pivot.

Is there a way I can trigger an event once the criteria changes in a
pivot table?


Regards,

andym

 

[Jim Thomlinson]

Selection change is not triggered when part of a pivot table is changed. You
want the Pivot Change event (which only exists in XL2002 and beyond).

 

[andym]

Thanks Jim....

looks like a good case for the boss to approve an upgrade!!!

Regards,

andym