Hey, I've got a problem. I have a spreadsheet that I'm using in which I put hyperlinks. Those hyperlinks link to various files in folders directly under the folder my spreadsheet is in. The hyperlink address looks something like this:

HW_design/board_review.doc

I want the hyperlink address to stay exactly as I entered it above because I will be sending this spreadsheet plus the folders and files under it out to many different places. Excel, however, keeps changing the addresses I've entered to point to those files only on my machine:

../../Application%20Data/Microsoft/Excel/HW_design/board_review.doc

I normally wouldn't care, but I have to put this bunch of files on CD's and on several different websites, so the second link won't work in those situations. I need the hyperlink to look directly at the folders in the same directory as itself for those files.

Ok, hope this makes sense and somebody can let me know why this is happening and, more importantly, how to stop it. Thanks.