Formula only returns values if the pages are open???

Hello,

So i have a workbook that draws numbers from other workbooks. For some reason every time i close and reopen it the fields are blank. I have to go in and open each workbook for the cells to populate. Is there something i am missing? I don't remember this happening before. Any help would be greatly appreciated.

Los

I am totally stumped on this, i have never had this happen before.

Anyone have a clue....