Hey Guys
Can any one suggest a simple method to modify the hyperlink path collectively??
I have a excel file containing hyperlinks say more that 500, and I want to move that file in another drive suppose from X to X_N or if I renamed it then I need to update the path of all hyperlinks. Do any one have easy way of doing instead of modifying it one by one.
For e.g. old file lying in X:\A\H\M\aaa.xls
and new file X_n:\A\HH\M\aaa.xls
Can any one suggest a simple method to modify the hyperlink path collectively??
I have a excel file containing hyperlinks say more that 500, and I want to move that file in another drive suppose from X to X_N or if I renamed it then I need to update the path of all hyperlinks. Do any one have easy way of doing instead of modifying it one by one.
For e.g. old file lying in X:\A\H\M\aaa.xls
and new file X_n:\A\HH\M\aaa.xls