Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Hyperlink won't open any other XLS file | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |