View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Moving xls files that have links??

Hi Bill,
When you move things around from one workbook to another be sure
to group the worksheets that are interrelated to one another together
as a group; otherwise, you will break links between worksheets.

You know what group is, I hope, the thing that if you forget to
ungroup you will damage everything because any change to one
sheet in a group will be made to all sheets in the group. So be
sure to ungroup immediately when finished with a group.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bill" wrote in message ...
Hi All,

When my current work is complete I am going to have to tidy up my working
documents which ate in different folders. Is there a way to do this and
preserve the links within them please?

Ta.
Bill