Copy Files with Links
Dear all,
I have 2 files (Rpt1.xls & Source1.xls) located in \\Sever\Version1 folder
and certain cells in Rpt1.xls are pointed to Source1.xls.
Later, I copy \\Sever\Version1 folder and its files to \\Sever\Version2
folder. The Rpt1.xls under Version2 folder is still point to
\\Sever\Version1\Source1.xls rather \\Sever\Version2\Source1.xls.
How can I solve it without change the links one by one becasue Rpt1.xls is
links above 20+ files under Version1 folder in fact. Before I update Excel
2003 , it is work.
Thanks!
Rdgs,
John
|