Excel link updates

I have a main excel file the has links from many other excel files (lets say A, B and C).

When I open the main file and at file A  ---  I get #value in the cells that are linked to files B and C.

How can you stop this from happening?