ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlink Redirection (https://www.excelbanter.com/excel-discussion-misc-queries/96461-hyperlink-redirection.html)

JayH

Hyperlink Redirection
 
When creating a link in an excel document on shared drive "A" which links to
a file on a seperate share "B" everything is fine until the file is saved on
share "A"

once the file is saved the link is changed and now inserts the files path
and then the links path afterwards, removing the original link path.

for example..
file share1.xls is on the share "work" E:\Excel directory, and links to file
custom.xls on share "extras" F:\Additions. link works fine until the
share1.xls file is saved, now when the link is opened it attempts to open

.../../extras/additions/test.xls instead of just extras/additions/test.xls
so rather than linking to the F: share, it changes it to try and link to the
E: directory of the saved file

therfore trying to find the link in the files own home directory rather than
where it was originally directed.
i have tried updating office and patching but still come up with this same
issue when linking between shared drives.

Anyone have any clue what to attempt next?
thanks in advance

JayH

Hyperlink Redirection
 
solving my own issue... but ill post it for future reference.
this issue was solved with a hotfix which has since been implimented in a
recent service pack HOWEVER it didnt appear to work, so i followed the steps
to recreate the hotfix myself
http://support.microsoft.com/?scid=k...509&sid=global

"JayH" wrote:

When creating a link in an excel document on shared drive "A" which links to
a file on a seperate share "B" everything is fine until the file is saved on
share "A"

once the file is saved the link is changed and now inserts the files path
and then the links path afterwards, removing the original link path.

for example..
file share1.xls is on the share "work" E:\Excel directory, and links to file
custom.xls on share "extras" F:\Additions. link works fine until the
share1.xls file is saved, now when the link is opened it attempts to open

../../extras/additions/test.xls instead of just extras/additions/test.xls
so rather than linking to the F: share, it changes it to try and link to the
E: directory of the saved file

therfore trying to find the link in the files own home directory rather than
where it was originally directed.
i have tried updating office and patching but still come up with this same
issue when linking between shared drives.

Anyone have any clue what to attempt next?
thanks in advance



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

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