L
Lance
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 Insert>Name>Define but I
get the same message.
Any help would be appreciated.
Thanks,
Lance
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 Insert>Name>Define but I
get the same message.
Any help would be appreciated.
Thanks,
Lance