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
David McRitchie - 01 Nov 2006 11:22 GMT
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
> Hi All,
>
[quoted text clipped - 4 lines]
> Ta.
> Bill
macropod - 02 Nov 2006 07:57 GMT
Hi Bill,
Provided you maintain the same folder names and relationships, moving them
as a group to a new parent folder should work fine.
If the folder names and/or relationships change, you'll need to update the
links. For each target worksheet, you can use Edit|Links to point to the new
source workbook location.
Cheers

Signature
macropod
[MVP - Microsoft Word]
> Hi All,
>
[quoted text clipped - 4 lines]
> Ta.
> Bill