I have a pivot table link to a query in a MAccess
database. Took me a long time to format the report...
Now, when I move the excel file on the server with the
database, the pivot table still point to the one on my C:
drive. How can I change the datasource without creating
a new pivot table and reformating?

even when I reassign a
new "ActiveWorkbook.PivotCaches.Connection" string, and
refresh, doesn't seem to work.

Thanks!