Forum Discussion
TRichardson35
Apr 13, 2022Copper Contributor
VLOOKUP Formulas stopped working
Hi! I have two files that are linked. They are linked with a VLOOKUP formula. They have been working until this week. I'm trying to find the reason the VLOOKUP formula doesn't work anymore. When...
Martin_Weiss
Apr 14, 2022Bronze Contributor
I assume, that both files are open, right? If yes, and if the VLOOKUP does not work, could you check if the workbook calculation mode is switched to manual?
Usually, this should be set to "Automatic"
TRichardson35
Apr 18, 2022Copper Contributor
Martin_Weiss Thank you! Let me check.