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