Change external source location of Pivot table in EXCEL2003 via VB

[Martijn]

Hi,

I got some pivots retreiving data from access databeses. Now I changed the
loctaions of these files and I want to change my pivot in Excel2003 so it`s
pointing to the new location. How can I do this in VBA?

Thanks,

Martijn