AnkitHanda
New Member
Hi,
I need help in editing links of a worksheet with more than 100
links like this -
Now excel file is in March'11 folder with below link-
D:F&FFeb 11 - CircleAAGA - AA_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleABGA - AB_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleAAOther Cost - AA_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleABOther Cost - AB_F&F_FEB_2010-11.xlsx
Now I want to change link by this-
D:F&FMar 11 - CircleAAGA - AA_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleABGA - AB_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleAAOther Cost - AA_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleABOther Cost - AB_F&F_MAR_2010-11.xlsx
I know Ctrl + H can be done... but there are so many links like this
in it the worksheet that everytime excel stop responding to it.
Please create a marco for it, because its very tedious and time
consuming.
Thanks in advance!!!
I need help in editing links of a worksheet with more than 100
links like this -
Now excel file is in March'11 folder with below link-
D:F&FFeb 11 - CircleAAGA - AA_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleABGA - AB_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleAAOther Cost - AA_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleABOther Cost - AB_F&F_FEB_2010-11.xlsx
Now I want to change link by this-
D:F&FMar 11 - CircleAAGA - AA_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleABGA - AB_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleAAOther Cost - AA_F&F_MAR_2010-11.xlsx
D:F&FMar 11 - CircleABOther Cost - AB_F&F_MAR_2010-11.xlsx
I know Ctrl + H can be done... but there are so many links like this
in it the worksheet that everytime excel stop responding to it.
Please create a marco for it, because its very tedious and time
consuming.
Thanks in advance!!!