Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Set the File, Properties, Hyperlink Base to "\\" (without the inverted commas).
This may intitially break a few links (but maybe not), but if you go back and set all your hyperlinks again to an absolute path on your LAN it should solve any further broken links. "Worthy" wrote: I am writing user manuals for a series of reports I produce and I'm using hyperlinks to show where reports are stored. When I insert the hyperlink it loses the full name of the file path and replaces it with the drive letter that the report is stored on. (i.e. instead of \\uup-rep-dx89\MI_Reports\daily\test.xls the hyperlink is shown as E:\MI_Reports\daily\test.xls.) Although the hyperlink will still work, it is not very practical for somebody to follow the user manual if they have a print out because network drives can be mapped to different drive letters. Hope this makes sense and hope somebody can help! Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why no XML in Excel 2003 with Office Standard? | Excel Discussion (Misc queries) | |||
Hyperlink to a location on worksheet and display full image. | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlink problem. | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlink problem. | Excel Discussion (Misc queries) | |||
trying to open an excel file in excel 2003 | Excel Discussion (Misc queries) |