There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html


Eli Shichrur wrote:
In office 2003 there is a new option
instead of the formula $a$10 the excell prevides getpivotdate when there is
a pivot table in this area

i want to cancel this option that added if office 2003, and i dont know how
to do it


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html