Using Windows XP Excel 2003, I want to move and copy a pivot table and its'
source data from it's original file into a new file. The issue is that once I
get it moved over, the pivot table still shows that it is linked to the
orginial source file. I have used the wizard and highlighted the new source
data but when I try to proceeed it tells me the pivot table name is not
valid. I have tried naming the source data through InsertNameDefine but I
get the same message.

Any help would be appreciated.

Thanks,
Lance