Home

Look ups only working if file open

%3CLINGO-SUB%20id%3D%22lingo-sub-814747%22%20slang%3D%22en-US%22%3ELook%20ups%20only%20working%20if%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814747%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20the%20latest%20update%20in%20excel%2C%20all%20links%20%2F%20lookups%20into%20other%20files%20do%20not%20work%20unless%20the%20other%20file%20is%20open.%20Never%20before%20did%20you%20have%20to%20have%20the%20source%20file%20open.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20if%20this%20can%20be%20fixed%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-814747%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
Joanna410
Occasional Visitor

Hi

 

Since the latest update in excel, all links / lookups into other files do not work unless the other file is open. Never before did you have to have the source file open. 

 

Any ideas if this can be fixed ?

 

Thanks

Related Conversations