Put the names in source workbook. When creating the PT specify the
name rather than the range.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

I am looking for a solution to simultaneously take of advantage of the
Dynamic Range as explained by Debra :
http://www.contextures.com/xlNames01.html#Dynamic
and keep the source database in a separate workbook, different from the
one which contains all the pivot tables ...

Thanks in advance for your comments
Cheers
Carim