Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Jun 15, 9:06*pm, Dave Peterson wrote:
I would have guessed that the C: would work better. *It's worked for quite a few other people. But I really like the =hyperlink() worksheet function. *That never fails <vbg. George R. wrote: In properties, I changed it to point to the subfolder on the network server where the hyperlinked document is located (not C, which is my local hard drive as this didn't work). *So far this seems to work. *I apreciate this suggestion as well as thehyperlinkformula approach as well! "Dave Peterson" wrote: A few people have said that this has stopped a similar problem from occurring. Maybe it'll help you--but you'll have to test it to make sure. In xl2003 menus: File|Properties|Summary Tab|HyperlinkBase change it to C:\ (something that's always available) In xl2007: Click on the Office button Choose Prepare, then properties. Then use the arrow on the Document Properties dropdown Choose Advanced Properties And then change thehyperlinkbase on the Summary tab. I like to use the =hyperlink() worksheet function. *It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") George R. wrote: I have aHyperlinkin my worksheet that points to a document on our network server, but when I save thisfileand email it to the group thehyperlink changes to point to my hard drive where the document is not located.. Tools - Options - General - Web Options - Files - Uncheck update links on save doesn't work. * Also, I erased thefiledefault location as this was pointing to my hard drive; this seemed to work for awhile but not any more. -- Dave Peterson -- Dave Peterson Hi I have had similar problems with hyperlinks across a LAN. It looks like the =hyperlink() function will sort it out but I can't seem to get the syntax with in the brackets right. Any advice? Cheers Davva |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel hyperlink loses its path on save (2) | Excel Discussion (Misc queries) | |||
Hyperlink to File name and path VBA Excel | Excel Discussion (Misc queries) | |||
Excel hyperlink loses its path on save | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Hyperlink loses reference | Excel Worksheet Functions |