ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinks change on save (https://www.excelbanter.com/excel-discussion-misc-queries/133551-hyperlinks-change-save.html)

F Laufs

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

Dave Peterson

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

F Laufs

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



All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com