I have hyperlinked documents in a spreadsheet and have saved the spreadsheet in a parent folder along with the documents.
I want to transfer this folder from my computer to a CD. As this transfer changes the file name, the hyperlinks no longer work.

I have tried editing the hyperlink, changing the base of the hyperlink to only the parent folder that the CD will also contain, making the file name less specific. I have also tried changing the base of the file name to D:, but have not yet been successful.
Also, when I try editing the hyperlink, the backwards slashes (\) that I type are changed to forward slashes (/) once the hyperlink is made; I then get a message that the hyperlink gives an invalid address.

Any help with this problem would be greatly appreciated.
Dalyce.