problem in Hyperlinks

[Ramadan]

Hi All,
I have a problem in my excel sheet!
the problem is : I made an excel sheet with hyperlinks to
some folders on the network
now if I mover this excel sheet from the original location
then I get no access to that folders because the path
was incorrect.
my question: Is there any option in the excel sheet to
make the hyperlink relative to the location of the sheet
and is this option valid incase I send the excel sheet by
email to any one in the same network.

thank you very much for help

 

[Ilan Rencus]

In Excel 97, I don't have other vertions, in the window of "Insert
Hyperlink" check "use relative path for hyperlink", at the bottom of
the window.
Ilan