Hi guys.. here is my dilemma regarding hyperlinks in excel.

I have a folderXXX in my server and occasionally I copy this folder and rename it to something like folderYYY to start my new project using the same set of files/folder inside it. Inside the \\server\folderXXX\folder00 there is a excel file (hyperlink.xls) which contains the hyperlinks below:

\\server\folderXXX\folder00\hyperlink.xls (text to display is hyperlink.xls)
\\server\folderXXX\folder01\word.doc (text to display is word.doc)
\\server\folderXXX\folder02\excel.xls (text to display is excel.xls)
\\server\folderXXX\folder03\p.ppt (text to display is p.ppt)

Now once I have the new folderYYY, the hyperlink.xls file still uses the folderXXX and I want to rename it to folderYYY. I know I can easily use the find/replace option but that is if I display the hyperlink in full like \\server\folderXXX\folder00\hyperlink.xls. However, I display my hyperlink as only the file itself to make it cleaner.

Is there a way to rename the hyperlink by not displaying it as a full hyperlink?

Thanks in advance!