Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I stop Excel 2003 from changing my hyperlinks on close?
I have a document with links to files on a shared network drive. On one
computer the links get changed to local links on close. EG. I link to \\server\myfile It works fine till I close and I get /../../../myfile What is going on? |
#2
|
|||
|
|||
A couple of people have posted that setting the hyperlink base will stop this
"helpful" behavior. File|properties|summary tab Hyperlink Base: C:\ (C:\ should be available) blobaugh wrote: I have a document with links to files on a shared network drive. On one computer the links get changed to local links on close. EG. I link to \\server\myfile It works fine till I close and I get /../../../myfile What is going on? -- Dave Peterson |
#3
|
|||
|
|||
Ps. I like to use the =hyperlink() worksheet function. It behaves much nicer.
blobaugh wrote: I have a document with links to files on a shared network drive. On one computer the links get changed to local links on close. EG. I link to \\server\myfile It works fine till I close and I get /../../../myfile What is going on? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) |