Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I extract and save hyperlinks from images in excel Robert in Brisbane Excel Discussion (Misc queries) 4 December 29th 06 12:55 PM
Hyperlinks breaking when save/reopen file... taylorj Excel Discussion (Misc queries) 2 April 3rd 06 09:33 AM
Everytime I save my workbook, my hyperlinks will no longer work. NUMBnut Excel Discussion (Misc queries) 0 December 30th 05 09:00 PM
Hyperlinks change path on save in Excel 2003 Flyboy Excel Worksheet Functions 1 November 5th 05 04:53 PM
Why do long hyperlinks get truncated on save in Excel? colerb Excel Worksheet Functions 1 June 13th 05 10:37 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"