Excel Help

Hoping someone can help me here.  I have a workbook in Excel that has links to several other workbooks.  All are saved on a server, whenever I close the main book that and then re-open, all of the linked cells have a #ref instead of the date that is supposed to be there.  How do I get the data to stay or to auto update the sheet?  Getting very frustrated....