Ian wrote:
I can't find a way to reestablish the link
without recreating all the tables.


You need to change the Connection property of the PivotCache(s) used by
the tables. There is no user interface for this in Excel.

I have a utility that might do it for you.

If you would like to try it email me at Bill_Manville @ compuserve.com
(without the spaces) and remind me that your interest is in moving
pivot table sources from desktop.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup