I have a series of workbooks that have been revised and then saved with the same name but with a revised date added to the file name - abc.xls, abc rev 9-23-03.xls, abc rev 9-25-03.xls etc. When I open any one of these work books I get a message that says that the workbook I opened contains automatic links to information in another workbook and asks if I want to update this workbook with changes made to the other workbook. Is there a way to remove these automatic links? I have tried Tools, Options, Calculation, and unchecked the update remote references but this doesn't help. Is there something I am missing?
Thanks for your help.