In a private reply, I suggested that the code may be in the wrong spot.

I said to verify that the code is behind the worksheet with the pivottables--by
rightclicking on the worksheet tab, selecting view code and pasting the code
into the code window.

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.

--

Dave Peterson