I have created a Pivot table having one Macro in the
Worksheet_calculate sub.In this macro I dynamically change the
formula of a calculated field depending upon the selection made in one
of the page fields.

How ever I am having a strange problem in this pivot. Here UNDO and
REDO buttons are disabled/

Can any one please suggest me how to correct this?