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  

Hyperlinks Randomly Change



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2008, 06:02 AM posted to microsoft.public.excel.links
Steve
external usenet poster
 
Posts: 2,662
Default Hyperlinks Randomly Change

Operating system is Windows 2003 with MS Office 2003. We have numerous Excel
workbooks with multiple spreadsheets in each. We have many hyperlinks within
each spreadsheet that links to many different directories/folders thus, not
allowing us to use Hyperlink Base.

When we establish the links they work for days, weeks, months, but then for
some unknown reason the links change. We have noticed one condition that
causes the hyperlinks to change. When we are updating a workbook and Excel
hangs up and when the files are recovered some of the links, or most of the
links and sometimes all hyperlinks change to an invalid path thus we are not
able to open the files. We have written a VBA procedure to help in these
instances by changing the links back to the original state. In addition, we
are backing up the files three times a day.

Following is the original value/address of the hyperlink:

...\..\..\dirnam1\dirnam2\dirnam3\dirnam4\dirnam5\ filename

where dirnam is the different directory levels.

Following is what the modified hyperlink changes to, but not always:

C:\myname\myhomedir\myid\dirnam1\dirnam2\dirnam3\d irnam4\dirnam5\filename

During the investigation of these issues we printed out all the hyperlinks
with in the worksheets. We noted that some hyperlinks have all slashes (“/”)
while other hyperlinks have all backslashes (“\”). There doesn’t appear to
be a significance between them because both type of slashes work. But, why
is there an inconsistency and is there a significance between them?

Thank you for your time.

  #2  
Old February 18th, 2009, 07:58 PM posted to microsoft.public.excel.links
booker@mgt[_2_]
external usenet poster
 
Posts: 21
Default Hyperlinks Randomly Change

Steve,
Did you ever find a resolution. We have an 07 environment where the same
thing happens.

For us, our network share is

it's a CIFS/SMB filesystem on a Sun StorageTek 5320C NAS running NAS
OS version 4.21



"Steve" wrote:

Operating system is Windows 2003 with MS Office 2003. We have numerous Excel
workbooks with multiple spreadsheets in each. We have many hyperlinks within
each spreadsheet that links to many different directories/folders thus, not
allowing us to use Hyperlink Base.

When we establish the links they work for days, weeks, months, but then for
some unknown reason the links change. We have noticed one condition that
causes the hyperlinks to change. When we are updating a workbook and Excel
hangs up and when the files are recovered some of the links, or most of the
links and sometimes all hyperlinks change to an invalid path thus we are not
able to open the files. We have written a VBA procedure to help in these
instances by changing the links back to the original state. In addition, we
are backing up the files three times a day.

Following is the original value/address of the hyperlink:

..\..\..\dirnam1\dirnam2\dirnam3\dirnam4\dirnam5\f ilename

where dirnam is the different directory levels.

Following is what the modified hyperlink changes to, but not always:

C:\myname\myhomedir\myid\dirnam1\dirnam2\dirnam3\d irnam4\dirnam5\filename

During the investigation of these issues we printed out all the hyperlinks
with in the worksheets. We noted that some hyperlinks have all slashes (“/”)
while other hyperlinks have all backslashes (“\”). There doesn’t appear to
be a significance between them because both type of slashes work. But, why
is there an inconsistency and is there a significance between them?

Thank you for your time.

  #3  
Old March 17th, 2009, 08:29 PM posted to microsoft.public.excel.links
LisaK
external usenet poster
 
Posts: 143
Default Hyperlinks Randomly Change

I'm also trying to figure out why a link is breking - 07 versions.

"booker@mgt" wrote:

Steve,
Did you ever find a resolution. We have an 07 environment where the same
thing happens.

For us, our network share is

it's a CIFS/SMB filesystem on a Sun StorageTek 5320C NAS running NAS
OS version 4.21



"Steve" wrote:

Operating system is Windows 2003 with MS Office 2003. We have numerous Excel
workbooks with multiple spreadsheets in each. We have many hyperlinks within
each spreadsheet that links to many different directories/folders thus, not
allowing us to use Hyperlink Base.

When we establish the links they work for days, weeks, months, but then for
some unknown reason the links change. We have noticed one condition that
causes the hyperlinks to change. When we are updating a workbook and Excel
hangs up and when the files are recovered some of the links, or most of the
links and sometimes all hyperlinks change to an invalid path thus we are not
able to open the files. We have written a VBA procedure to help in these
instances by changing the links back to the original state. In addition, we
are backing up the files three times a day.

Following is the original value/address of the hyperlink:

..\..\..\dirnam1\dirnam2\dirnam3\dirnam4\dirnam5\f ilename

where dirnam is the different directory levels.

Following is what the modified hyperlink changes to, but not always:

C:\myname\myhomedir\myid\dirnam1\dirnam2\dirnam3\d irnam4\dirnam5\filename

During the investigation of these issues we printed out all the hyperlinks
with in the worksheets. We noted that some hyperlinks have all slashes (“/”)
while other hyperlinks have all backslashes (“\”). There doesn’t appear to
be a significance between them because both type of slashes work. But, why
is there an inconsistency and is there a significance between them?

Thank you for your time.

 




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 08:54 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.