Linked workbooks - main workbook keep old values <p>I have a main workbook with many cells linked to other workbooks cells. </p> <p>The source workbooks must be replaced from time to time and some of them sometimes are just erased. </p> <p>For those cells in the main workbook linked to deleted source workbooks I was expecting to get "#REF!", but instead I get old values, from the deleted workbooks. </p> <p>Is there a way I can get rid of old values and get "#REF!" or blank cells instead? </p>