Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Broken Links | Excel Discussion (Misc queries) | |||
broken links | Excel Discussion (Misc queries) | |||
Broken Links.... | Excel Discussion (Misc queries) | |||
Broken Links | Excel Discussion (Misc queries) | |||
Links are broken and cannot fix | Excel Worksheet Functions |