Thread: How keep links when copy worksheets to another file?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack B Jack B is offline
external usenet poster
  
Posts: 21
Default 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


Reply With QuoteReply With Quote