The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Find and Replace – Reference

Find and Replace – Reference

Super Learner
0
Votes
2
Answer

I’m lost when the video explaining the external/internal reference. Anybody can provide more examples to help me understand it?

2 Answers

365 Team
0
Votes

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

Super Learner
0
Votes

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.

×
Learn Data Science
this Summer!
Get 50% OFF