Dear All,

We have a set of worksheets that all drag data into pivot tables from an access database.

We have moved the XL sheets and the database due to corporate file restructuring.

How do I tell the pivot tables that the database they want to get their data from has moved?

any ideas would be appreciated.

andy