Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks change on save
Hi,
Using Office 2003, when I enter the appropriate text into a cell, a hyperlink is auotmatically generated. I am happy with this. The link even works... until I save the workbook. The pre-save link (I'm checking the actual link through Edit Hyperlink) looks like this: \\server\Shared Folders\Information management\Records management The post-save link looks like this: .../../../../../Shared%20Folders/Information%20management/Records%20management Why is this change taking place? Any insight appreciated. FLaufs |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks change on save
Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them
with by using the =hyperlink() worksheet function. ====== I'm not sure if this will work with your hyperlinks, but 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) F Laufs wrote: Hi, Using Office 2003, when I enter the appropriate text into a cell, a hyperlink is auotmatically generated. I am happy with this. The link even works... until I save the workbook. The pre-save link (I'm checking the actual link through Edit Hyperlink) looks like this: \\server\Shared Folders\Information management\Records management The post-save link looks like this: ../../../../../Shared%20Folders/Information%20management/Records%20management Why is this change taking place? Any insight appreciated. FLaufs -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks change on save
Dave
I have used the =hyperlink() function in this particular situation and it works. I have also changed the the Hyperlink Base to C:\ and tested that and it seems to work! Thank you so much! "Dave Peterson" wrote: Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them with by using the =hyperlink() worksheet function. ====== I'm not sure if this will work with your hyperlinks, but 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) F Laufs wrote: Hi, Using Office 2003, when I enter the appropriate text into a cell, a hyperlink is auotmatically generated. I am happy with this. The link even works... until I save the workbook. The pre-save link (I'm checking the actual link through Edit Hyperlink) looks like this: \\server\Shared Folders\Information management\Records management The post-save link looks like this: ../../../../../Shared%20Folders/Information%20management/Records%20management Why is this change taking place? Any insight appreciated. FLaufs -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I extract and save hyperlinks from images in excel | Excel Discussion (Misc queries) | |||
Hyperlinks breaking when save/reopen file... | Excel Discussion (Misc queries) | |||
Everytime I save my workbook, my hyperlinks will no longer work. | Excel Discussion (Misc queries) | |||
Hyperlinks change path on save in Excel 2003 | Excel Worksheet Functions | |||
Why do long hyperlinks get truncated on save in Excel? | Excel Worksheet Functions |