Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How keep links when copy worksheets to another file?
I want to move 2 worksheets (Alpha & Beta) from file ABC.xls to STU.xls,
then I'll delete ABC.xls. Beta is linked to Alpha, and I want to keep the links. However, when I copy/move Alpha & Beta to STU.xls, the Beta worksheet links back to Alpha in file ABC.xls. How do I copy/move Alpha & Beta to STU.xls so that Beta is linked to Alpha in file STU.xls? Jack |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How keep links when copy worksheets to another file?
If Beta is linked to just Alpha you should not get any links back to ABC
after copying or moving. But since you say it does................ After copying the two sheets to STU.xls With STU.xls open go to EditLinksChange source. Link to STU.xls The links between Alpha and Beta will remain with no reference to ABC.xls Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 11:28:13 -0500, "Jack B" wrote: I want to move 2 worksheets (Alpha & Beta) from file ABC.xls to STU.xls, then I'll delete ABC.xls. Beta is linked to Alpha, and I want to keep the links. However, when I copy/move Alpha & Beta to STU.xls, the Beta worksheet links back to Alpha in file ABC.xls. How do I copy/move Alpha & Beta to STU.xls so that Beta is linked to Alpha in file STU.xls? Jack |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How keep links when copy worksheets to another file?
Gord, Since you said, "If Beta is linked to just Alpha you should not get any links back to ABC," I decided to do a MOVE instead of a COPY -- that worked. Thanks. Jack ----------------------------------- "Gord Dibben" <gorddibbATshawDOTca wrote in message ... If Beta is linked to just Alpha you should not get any links back to ABC after copying or moving. But since you say it does................ After copying the two sheets to STU.xls With STU.xls open go to EditLinksChange source. Link to STU.xls The links between Alpha and Beta will remain with no reference to ABC.xls Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 11:28:13 -0500, "Jack B" wrote: I want to move 2 worksheets (Alpha & Beta) from file ABC.xls to STU.xls, then I'll delete ABC.xls. Beta is linked to Alpha, and I want to keep the links. However, when I copy/move Alpha & Beta to STU.xls, the Beta worksheet links back to Alpha in file ABC.xls. How do I copy/move Alpha & Beta to STU.xls so that Beta is linked to Alpha in file STU.xls? Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file links incorrect when file is re-opened | Excel Worksheet Functions | |||
Links between worksheets and more... | Excel Worksheet Functions | |||
Links to other worksheets | Links and Linking in Excel | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |