I have 10 links to 10 other workbooks in one file ("MAIN BOOK"), one cell for every link. These are not formulas, just simple references to a cells from other workbooks.

I'll give an example that I think best describes my problem
In cell A1 "MAIN BOOK" there is value let say 50.000 it's reference to a A1 cell from "Source book 1". In cell A1 "Source book 1" value has been changed to 20.000, and now when I open "MAIN BOOK" in A1 still stand 50.000.

Number is updated ONLY when I open "Source 1" book, and here is the strangest thing, after I save "MAIN BOOK" (with now updated value) and open it again there is an old value of 50.000. It looks like he fetches this value from some cache file. I don't know.


I've tried changing setting in trust center (Enable all data connections) and nothing happens.