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)
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