Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Editing Link Source
I am copying a worksheet from one workbook to another. this creates
links in the destination workbook. I am surpressing the update links message, however when the source can not be found a window asking to find the source pops up. I am looking for a way to do any of the following: 1. Set the link source so it looks in the destination workbook which is looking for a source file. 2. Skip the update link procedure all together, in a way that the user will never see 3. Perform the copy without creating a link in the first place The formulas that contain links get overwritten in a subroutine but the workbook still thinks it needs to update links. This wasnt a problem until files began getting passed across a network and the path to the link source was no longer the correct path. (i.e. the link source file doesnt reside on the local computer.) Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing Source Data in Charts | Charts and Charting in Excel | |||
How change link source in long formula when source moved | Excel Programming | |||
MSQuery editing source data? | Excel Discussion (Misc queries) | |||
Auto Editing the Row source. | Excel Programming | |||
How to link worksheets so editing one will edit others automatica | Excel Worksheet Functions |