Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1514646%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514646%22%20slang%3D%22en-US%22%3E%3CP%3EHoping%20someone%20can%20help%20me%20here.%26nbsp%3B%20I%20have%20a%20workbook%20in%20Excel%20that%20has%20links%20to%20several%20other%20workbooks.%26nbsp%3B%20All%20are%20saved%20on%20a%20server%2C%20whenever%20I%20close%20the%20main%20book%20that%20and%20then%20re-open%2C%20all%20of%20the%20linked%20cells%20have%20a%20%23ref%20instead%20of%20the%20date%20that%20is%20supposed%20to%20be%20there.%26nbsp%3B%20How%20do%20I%20get%20the%20data%20to%20stay%20or%20to%20auto%20update%20the%20sheet%3F%26nbsp%3B%20Getting%20very%20frustrated....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1514646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies