Hi
you may use an event procedure for this. e.g. the
worksheet_calculate event. See
http://www.cpearson.com/excel/events.htm

-----Original Message-----
Hi All,

How can I trigger a macro everytime the user refresh the
Pivot Table? I am new to this area. Help with this code
would be appreciated. Thanks in advance

Regards

M
.