|
Training Index l How
errors happen l Vital Tips
Links:
| Although it is nice to be able to trace relationships between cells over
multiple workbooks, it sometimes arises that the spreadsheet has an external
link that you cannot easily find. The first trick is to identify what the link is referring to. Excel has
addressed the issue by giving you the LINK feature. When you are in a
workbook that indicates that there is an external link, do the following:
|
|
|
- Click Edit > Links
|
 |
This will bring up a screen that will indicate what other spreadsheets
are being referenced to. It also allows you to automatically change the
links in the spreadsheet to a new link, update links and the like.
However, it does not identify the actual cells that contain
the link and this is sometimes required. Therefore we need to find another
workaround.
|
