Update Hyperlinks Automatically when Folder Name or Location Change

hi everyone just want to ask about hyperlink if possible that excel will automatically update hyperlink when folder change or location so that i will not link again one by one. my files is in the server the problem is i will move the excel file and change the folder name that are link to to excel. thank you in advance

It's not possible to do it automatically, but you could run something like

Please Login or Register  to view this content.

To bulk update hyperlinks. Use whatever method you choose to populate OldPath & NewPath

thank you for your reply. but my hyperlink is not a formula what i did is right click the cell hyperlink then browse for the file.