chris,

That is a good question, one I will watch to see if it gets answered.
However, one way to accomplish what you want is to create
the links when/where you need them.
Store the files on the CD and use a utility that creates links to those files.
You could install the utility on each machine that will use the CD or
create several workbooks that are each linked to a particular drive.

I should note that good practice dictates that one should copy
XL files to the hard drive and open them from there.

My free "List Files" Excel add-in will do the job.
Download from here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"cdroot4383" wrote in message
Hi,
I'm creating a spreadsheet that hyperlinks to about 50 different
documents. Eventually, i want a CD to contain the excel file and all
the hyperlinked documents. To get the hyperlinks to run from the cd, i
had to change all of the hyperlinks within my spreadsheet to the E:\
(this is the drive where my burner is). I then inserted the cd into a
different computer (D:\) and none of my hyperlinks work anymore? Is
there anyway to make sure that the excel hyperlinks open to the files
stored on the cd, regardless of which drive it is in?
thanks in advance,
chris