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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies