I guess you mean the code that Dave Peterson suggested in this thread:


http://groups.google.ca/group/micros...5c284c4?hl=en&

Which code did you use, and where did you store the code?

Luc Poppe wrote:
I need to auto refresh a pivot table on a worksheet in Excel 2002. Tried to
use suggested macro from Dave Patterson of 8/23/04 in this forum, but it does
not work, it was a macro for excel 2000. I have no experience with Visual
Basic.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html