Forum Discussion
Hyperlink Issue For Pictures
Description of link management and storage in Excel
Hyperlinks to other folders are usually inserted by Excel as "relative references" (e.g. folder name\file.xls). After being moved, these links then lose their target effect.
It is therefore important to get the application program to insert "absolute references"
(e.g. \\computername\foldername\file.xls) in such a case.
With a small entry in the file properties, you can force Excel to use absolute hyperlinks in the workbook. To achieve this, do the following...It depends on Excel version:
After inserting the hyperlinks, save the file.
Now click on the "File" tab and then on "Get Info".
Next click on "Properties" and "Advanced Properties".
In the dialog window that now opens, switch to the "Summary" tab.
In the Hyperlink Base field, type a period.
Confirm with OK".
Hope I could help you with these information / links.
I know I don't know anything (Socrates)