Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks changed automatically in excel.
I have a worksheet with hyperlinks to result files in one directory.
Somehow all the links were changed . Some to C:\Documents and Settings\MAM\Local Settings\Temporary Internet Files\OLK31\ some to n:\data but they were all changed from the correct path of n:\data\lab. Which actions could I of taken to change these without physically editing the hyperlink. I had quite a few of the data sheets open but not all that were changed. I am very puzzled and it it quite a bit of work to correct it. How can I avoid this problem from happening again. PS. I did not move the data it is still in the place it always was. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks changed automatically in excel.
A few people have said that this has resolved the problem for them:
File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") ============== If you have to change lots and lots and lots back... You could use the code from David McRitchie's site: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm (If it's just a few, I'd do it manually.) Sally wrote: I have a worksheet with hyperlinks to result files in one directory. Somehow all the links were changed . Some to C:\Documents and Settings\MAM\Local Settings\Temporary Internet Files\OLK31\ some to n:\data but they were all changed from the correct path of n:\data\lab. Which actions could I of taken to change these without physically editing the hyperlink. I had quite a few of the data sheets open but not all that were changed. I am very puzzled and it it quite a bit of work to correct it. How can I avoid this problem from happening again. PS. I did not move the data it is still in the place it always was. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changed Hyperlinks !! | Excel Worksheet Functions | |||
How to automatically create hyperlinks with excel | Excel Worksheet Functions | |||
How can I stop excel from automatically making hyperlinks | Excel Discussion (Misc queries) | |||
Looking to automatically "unhide" rows in excel using hyperlinks | Excel Discussion (Misc queries) | |||
How do I get a date changed automatically | Excel Worksheet Functions |