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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|