Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
move 2 worksheets & keep the links
Excel '97 --------
I want to move 2 worksheets (one is linked to the other) to another file. It is an Excel file called ''Xmas List.'' These are the 2 worksheets: List Relatives The Relatives worksheet is linked to the List worksheet (the List worksheet includes everybody). I want to move the 2 worksheets to an Excel file called ''Xmas 2003-2008.'' Xmas 2003-2008 has these 5 worksheets: 2003 2004 2005 2006 2007 But when I copy the 2 worksheets into ''Xmas 2003-2008,'' the ''Relatives'' worksheet stays linked to the ''List'' worksheet in the ''Xmas List'' file. Within the ''Xmas 2003-2008'' file, how do I make ''Relatives'' link to ''List''? Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Broken Excel Links - move files to another computer | Excel Discussion (Misc queries) | |||
Bug: Move or Copy sheet graph links not updating! | Excel Discussion (Misc queries) | |||
Links do move when a row is added | Excel Discussion (Misc queries) | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
How do I move workbooks w/o having to reset the links? | New Users to Excel |