If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Broken Links
I have created a series of workbooks and saved them in subfolders of a main
folder. Individual cells on the various sheets in the workbooks have links to other workbooks within this series. The problem I have is that when I copy the folder onto another computer then the links wont work as it is looking for the original file path, which has changed due to it being located in a diferent place on another computer. I can rectify this by removing the password protections of each sheet in all the workbooks and then, under links, changing the link source. Trouble is this is a huge amount of work. Anyone got any ideas on how I can overcome this, please? Many thanks |
#2
|
|||
|
|||
Broken Links
Why not do a global find and replace? This won't fix links that are
embedded in named ranges or charts. I seem to find more links in charts than anywhere else. I've not taken the time to figure out how they get there (I don't create them initially) , so if someone knows, let me know. -- HTH, Barb Reinhardt "JayBee" wrote: I have created a series of workbooks and saved them in subfolders of a main folder. Individual cells on the various sheets in the workbooks have links to other workbooks within this series. The problem I have is that when I copy the folder onto another computer then the links wont work as it is looking for the original file path, which has changed due to it being located in a diferent place on another computer. I can rectify this by removing the password protections of each sheet in all the workbooks and then, under links, changing the link source. Trouble is this is a huge amount of work. Anyone got any ideas on how I can overcome this, please? Many thanks |
#3
|
|||
|
|||
Broken Links
Thanks,
I'll give it a go. I suppose I'm looking for the equivalent of being able to run it stand-alone from, say a CD. Many thanks "Barb Reinhardt" wrote: Why not do a global find and replace? This won't fix links that are embedded in named ranges or charts. I seem to find more links in charts than anywhere else. I've not taken the time to figure out how they get there (I don't create them initially) , so if someone knows, let me know. -- HTH, Barb Reinhardt "JayBee" wrote: I have created a series of workbooks and saved them in subfolders of a main folder. Individual cells on the various sheets in the workbooks have links to other workbooks within this series. The problem I have is that when I copy the folder onto another computer then the links wont work as it is looking for the original file path, which has changed due to it being located in a diferent place on another computer. I can rectify this by removing the password protections of each sheet in all the workbooks and then, under links, changing the link source. Trouble is this is a huge amount of work. Anyone got any ideas on how I can overcome this, please? Many thanks |
Thread Tools | |
Display Modes | |
|
|