If you are facing any issue in playing video please use Firefox browser.
How to use Edit Links function
Now we will see that how we use edit links function in MS Excel.
For that we will for score to our data tab and then we will see an 'Edit links' option. It is not available on every worksheet file.
Basically link is where the information of our source file and destination file is stored.
It is mainly used to view all the other files this spreadsheet is linked to, so that you can update or remove the links.
We have already seen that how we can apply formula from different worksheets to single worksheets.
Now if we go to any of the cell and see its trace precedants, then we will notice that whichever cell data is used in any other formula is shown by some arrows. We can also remove those arrows by selecting Remove Arrow option.
So now like this how we can know that whose cell's trace precedents we should see. So for that we have another option which is known as trace dependents which will show that where this cell is used and on double clicking it will also mention the location.
So by using Edit links we can know that from where the data is coming particularly.
Now after performing all the task we can close our workbook file by pressing 'Ctrl+W' key.
Now for example we change some data from over source file, then when we go to our final file where formula is used, we can see a warning in the top mentioning 'Automatic update of links has been disabled'. We can Enable content by selecting it.
So this is how edit link works, if any data is coming from other file it will be activated in that particular file.
Have a friend to whom you would want to share this course?