Hi,

I have a file named ANS.xlsx in the following folder "C:\CALCULUS\ONE\1\CALS\ANS.xlsx" when i copy and paste folder "CALCULUS" it becomes C:\CALCULUS - Copy\ONE\1\CALS\ANS.xlsx

Everything is OK until now but the problem arises when i open ANS.xlsx . The thing is, that workbook ANS.xlsx contains some links. For example one of the links in ANS.xlsx is not updating automatically. After pasting CALCULUS the link at ANS.xlsx should have been like this "C:\CALCULUS-Copy\ONE\1\CALS\SEVEN.xlsx" but instead of that, the link remains as C:\CALCULUS\ONE\1\CALS\SEVEN.xlsx.

Please help me to resolve this unsolved issue.

Thanks in advance