Last answered:

17 May 2020

Posted on:

12 May 2020

0

Find and Replace - Reference

I'm lost when the video explaining the external/internal reference. Anybody can provide more examples to help me understand it?
2 answers ( 0 marked as helpful)
Instructor
Posted on:

13 May 2020

0
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
Posted on:

17 May 2020

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

Submit an answer