Hello.

I have a folder (:C/Documents/Main) that contains 3 more folders (folders A, B, & C containing excel files) and several other individual excel files. On one of the excel files in the Main folder i have hyperlinks set up to the files in folder C. The hyperlink path reads as

:C/Documents/Main/folderC/excelfile.xlsm.

I want to copy that hyperlink from the file in the Main folder to a file in folder A, but when I do the hyperlink path changes to

:C/Documents/Main/folderA/folderC/excelfile.xlsm.

Why does it do this, and is there a way to correct this action? I have many hyperlinks to set up and I would prefer to copy and paste them instead of have to do each one individually again.

Thanks