Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste hyperlinks between workbooks
I have encountered a problem. Workbook "A" contains several columns of
information, some of which is sensitive, and therefore of limited access. There are several columns of information, which is periodically updated. Workbooks "B" and "C" each contain some of the information from Workbook "A", in a limited form (i.e. of 20 columns in "A", "B" might contain 4 columns, and "C" might contain 5 different columns). Two of the columns in "A" (one of each ends up in "B" and "C") consists of hyperlinks to documents that reside on a different server within the organization, such that when you click the link, the document opens. For the sake of this discusssion, let's say that these documents live a "\\OtherServer\Main\Sub1\SubSub1\file1" and "\\OtherServer\Main\Sub2\SubSub2\file2". So the hyper link would be to that location. When new data comes in, it is updated in Workbook "A" manually. Then the relevant parts from "A" are copied and pasted into "B" and "C". Here's where the problem arises. When copying "\\OtherServer\Main\Sub1\SubSub1\file1" from "A" to "B", what ends up in "B" is "\\OtherServer\Main\Sub1\Main\Sub1\SubSub1\fil e1", and when someone clicks the link, it errors, since obviously that file doesn't exist. It happens every time a copy and paste is performed, and it always duplicates the 2nd and 3rd levels of the path: i.e. "\Main\Sub2" becomes "\Main\Sub2\Main\Sub2". "A", "B" and "C" all reside within the same folder, but it is different than the folder where the linked files are. I don't think that has anything to do with it, but not sure. Help anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
hyperlinks in different drives | Excel Discussion (Misc queries) | |||
Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |