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