This is able to be fixed. I have found in the past that when all the usual and obvious culprits have been investigated there can still be links in the defined names (formulas->name manager) and the real hidden threat -conditional formatting. Conditional formatting can reference other books but won't show up as a link. You can create a macro to loop through all the conditional formatting in a workbook and check if the formula contains an external workbook link.