VLOOKUP Formulas not updating when files are opened

[tomba12]

I have one excel workbook that serves as a high level sales dashboard for my team. This workbook links to 4 other workbooks that my team members update. The other 4 workbooks are independent of each other and all workbooks are saved on a shared network at work. Once the files are all updated I will open all 5 workbooks together to have all my VLOOKUP formulas refreshed and pull in the new data. However, lately when I open all the workbooks together, I notice that my formulas in the dashboard workbook do not update and that the formula will show the entire network path to where the other 4 workbooks are located. Can someone please help me to understand why the links are refreshing?

Thanks

[Mayda89]

maybe calculation setting could be turned to manual.
Go to settings and change it to automatic calculation.

[tomba12]

Calculation settings are set to calculate automatically. I believe that somehow the links are not remaining linked to the other workbooks. But I don't know why? Please help

[Mayda89]

can you upload sample workbooks (the one that has formulas, and one that contains data).

[abubaniyan]

once i have faced the same problem...so try this

---> 1. open all the excel sheets which contain your data (excluding your vlookup formula sheet which you want to update).
---> 2. after this open the vlookup formula sheet.