Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.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 |
#3
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 -- macropod [MVP - Microsoft Word] "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links won't update unless files are actually opened | Excel Discussion (Misc queries) | |||
Excel 2003 Opens Excel 97 Files & recalcs links | Excel Discussion (Misc queries) | |||
breaking links between excel files when one file already deleted? | Excel Worksheet Functions | |||
Help with Broken Links | Excel Discussion (Misc queries) | |||
Updating Links to Other Excel Files | Excel Worksheet Functions |