Vlookup between workbooks

[Eransa1965]

Hello, i wrote vlookup function in workbook A looking into data in workbook B.

It is working fine and shows the expected data.

I added data to workboob A that is missing in workbook B. The function as expected showing missing data. Wile file A is open, i added the missing data to file B and saved file B.

I was expecting file A now to show correctly the vlookup data. But it is still showing the data is missing.

By  closing file A and reopening it, Excel suggest me to reload external data. When choosing reload, the data now is shown correctly in file A. 

My question, is there a way to reload the external data into file A without closing the file?

Thanks, Eran Sarig 

[#2]

Here's how you can do it:
In Workbook A, go to the "Data" tab on the Excel ribbon.
Look for the "Refresh All" button in the "Connections" group.
Click on "Refresh All".

[#3]

Could you show me the formula you used for your task? I need to do something similar and am having trouble determining the correct values, etc,

[#4]

Basically there is a REFRESH button in the Ribbon. That's it!!