Find and Replace - Reference

Hi Ethan, Thanks for reaching out. I hope I can be of help. First of all, this is helpful in a very particular situation. We'll need this trick, if we have imported a worksheet from a previous version of the workbook, and some external references to the previous version of the file remain in place. We are removing the references to the external workbook and replacing them with nothing --> erasing external references. By doing this, Excel will find references to the same sheet in the current workbook and we wouldn't have to deal with external references. Hope this makes sense! Best, Ned

Hi Ned,  Thank you for the explanation. Just wondering, if we replace the external reference with nothing, does the value/data in the cell will go haywire?   Regards. Ethan.