Excel hyperlink loses its path on save (2)
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
|