How can I manage pivot table macros? Copied sources isn't safe

T

tascim

When I copied an excel sheet that including pivot table, I can not refresh
pivot table datas becouse of the sheet name changed. Cell referance names has
to be changed automaticly by the pivot table macros. Is there any solution of
this problem.
Thanks,
MT
 
Top