A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

lost Hypertext links defined in cells of an excel spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old October 7th, 2008, 02:25 PM posted to microsoft.public.excel.links
Eric
external usenet poster
 
Posts: 1,956
Default lost Hypertext links defined in cells of an excel spreadsheet

I've defined hypertext links defined in cells of an excel spreadsheet, that
are pointing on documents stored in different
folders. They work fine for a while...
Under some circomstances on my PC and each time I send the spreadsheet and
the folders the targets document are stored in,
the hypertext links don't work anymore, with either on or the other
following messages :
"The address of this site is not valid. Check the address and try again" or
"cannot open the specified file"

Is there a way to define those hypertext links without encoutering this
limitation ?
Thanks for your help.
  #2  
Old October 7th, 2008, 10:06 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default lost Hypertext links defined in cells of an excel spreadsheet

Hyperlink addresses can be saved as relative to some path (the path of
the workbook by default, or the workbook's "hyperlink base") or as
absolute addresses.

If you move the workbook then the relative hyperlinks no longer work.

For that reason I suggest setting a hyperlink base which does not
exist. This will force all hyperlink addresses to be absolute.

In Excel 2003 and earlier
File Properties Summary Hyperlink Base


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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