Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sooner1ksn
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
hyperlinks in different drives cdroot4383 Excel Discussion (Misc queries) 2 January 5th 06 08:35 PM
Links auto update on some workbooks but not others Tasza Excel Worksheet Functions 1 October 25th 05 01:04 AM
Workbooks...I'll try this again... Markster Excel Discussion (Misc queries) 10 December 7th 04 11:12 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"