see the macro at the bottom of article written by Harald Staff
Introduction To Pivot Tables
http://www.cpearson.com/excel/pivots.htm

You can find additional information on Pivot Tables on Debra Dalgleish's site
I think there is also a macro there to update Pivot Tables.
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Help me" wrote in message ...
Hi there

I was just wondering whether it is possible to refresh or relink the data
source of a pivot table programatically?

Example - Sheet 1 has 1 pivot table source: c:\mydb.mdb
Can i write some code to change the datasource of
Sheet 1 pivot table to h:\new location\sub folder\another sub\on a diff
drive\mydb.mdb

cheers