Unstable Link between Workbooks

Hello,

I have a question about linking between Workbooks. I have 2 Workbooks and some cells have Formulas targeting each other, formulas like IF, VLOOKUP... Etc...

I have it that way because the users cannot access other user whole information, even though there is no need of real time sync there is a need to share some of the information between the users.

So.. some cells with the formula appear as #REF, I have no idea what to do, I've searched everywhere, and seems that there is no need of visual basic here...
Is there a solution?


Thank you all!

So, I should Open all workbooks and update? I will give it a try.