Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep the absolute path in a huperlink
When I add a hyperlink i always add the hyperlink as the document is on
another shared drive. The link path keeps reverting to the format: ...\..\ and loses the link Any ideas how I can keep the absolute path? -- Nicola |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep the absolute path in a huperlink
If you're using Insert|hyperlink, try changing the base address:
File|Properties|summary tab (near the bottom of the dialog) (Point at the C:\ folder--it should be available for all users????) But I've never had any trouble using the =hyperlink() worksheet formula. =hyperlink("file:////c:\my documents\word\doc1.doc","Click Me") Nicola wrote: When I add a hyperlink i always add the hyperlink as the document is on another shared drive. The link path keeps reverting to the format: ..\..\ and loses the link Any ideas how I can keep the absolute path? -- Nicola -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute Path change ... | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Link a cell to another workbook with a different path | Excel Worksheet Functions | |||
Absolute vs Relative path | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |