Code should work in xl97. I assume you are deleting data in the source
table?

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in message
...
Cheers Tom,

I'm running Office 97 and the code says its deleting the pivot items but
it doesn't seem to have any effect on the pivot table.

Cheers,

Steven Revell
Applications Development & Support
Covance Laboratories Europe, UK

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!