Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lose my hyperlinks when file sharing
I have a file with hyperlinks for various form titles linking to that form.
I when I share it with my network (In office), the other computers on the network do not have the links. I have to go to that computer and reset all the hyperlinks. Is there a way to keep this from happening? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lose my hyperlinks when file sharing
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|Hyperlink Base 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 the hyperlink base on the Summary tab. =============== I like to use the =hyperlink() worksheet function for this. I'll put the path in a hidden cell (A1 in my example). (Include the trailing backslash, too!) Then put the filenames in A2:Axxx Then use the =hyperlink() formula in B2:Bxx. =hyperlink("File:////"&$a$1&a2,"Click me") and drag down Then when I need to change the folder, I can change it one location (A1). I could embed the path directly in the formula: =hyperlink("File:////c:\my documents\excel\"& a2,"Click me") and use Edit|Replace, but that seems like more work to me. ======== If you used Insert|Hyperlink, then you've noticed that edit|replace won't touch those hyperlink addresses. Saved from a previous post: If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Rich wrote: I have a file with hyperlinks for various form titles linking to that form. I when I share it with my network (In office), the other computers on the network do not have the links. I have to go to that computer and reset all the hyperlinks. Is there a way to keep this from happening? Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening file cause rows to lose | Excel Discussion (Misc queries) | |||
Why do i lose EOMONTH on file close | Excel Worksheet Functions | |||
file sharing | Excel Discussion (Misc queries) | |||
creating hyperlinks in excel that won't lose integrity when file m | Excel Worksheet Functions | |||
I lose cell comments in Excel when moving a file via a USb drive | Excel Discussion (Misc queries) |