vlookup formula won't update

[uivandal]

I have a vlookup in book 1 that references a list of values in book 2. When the numbers in the list in book 2 are updated, the vlookup in book 1 does not update. Do you know how I can address this?

 

[Luke M]

Are both workbooks open at the same time?

Do you need to update the links?

Is calculation mode in Automatic?

 

[uivandal]

Are both workbooks open at the same time? They are not.

Do you need to update the links? The link is stil valid, if that is what you are asking.

Is calculation mode in Automatic? It was not. I turned it on and the vlookup formula updated. Everytime I close book 1, it turns the automatic calculation mode off. Any idea of how to fix that?


Thank you for your help, I truly appreciate it.

 

[Luke M]

Hmm. I'm not aware of any "natural" way that would chance the calculation mode off. Is there a Workbook_Close event macro in book 1?

 

[SirJB7]

Hi, uivandal!

I reached the same point as Luke M. Can you please upload the file so as the check the whole code, just in case?

Regards!