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