Excel link updates

%3CLINGO-SUB%20id%3D%22lingo-sub-3104875%22%20slang%3D%22en-US%22%3EExcel%20link%20updates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3104875%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20main%20excel%20file%20the%20has%20links%20from%20many%20other%20excel%20files%20(lets%20say%20A%2C%20B%20and%20C).%3C%2FP%3E%3CP%3EWhen%20I%20open%20the%20main%20file%20and%20at%20file%20A%26nbsp%3B%20---%26nbsp%3B%20I%20get%20%23value%20in%20the%20cells%20that%20are%20linked%20to%20files%20B%20and%20C.%3C%2FP%3E%3CP%3EHow%20can%20you%20stop%20this%20from%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3104875%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

 

0 Replies