Well, there's two options. The long way is to just copy the sheet over and
re-create the pivot.

The easier one would be to right-click within the pivot table, go to Pivot
Table Wizard, hit the back button once, and adjust the range from there.

"Lance" wrote:

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