Forum Discussion
Vlookup between workbooks
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
3 Replies
- 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,
- Basically there is a REFRESH button in the Ribbon. That's it!!
- 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".
