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....