Forum Discussion
Trying to find cell with a source link
I have inherited an Excel Workbook. When the file its open it says it cannot find a source link to update. The file it is calling is old and does not exist. So I want to find the cell that is trying to call to that source. I tried FIND - search for .xl - WORKBOOK - In FORMULAS and it is not found. I can see the link in EDIT LINKS so I know what file it is calling but cannot find the cell. I could tell it on Start Up prompt to ignore the error and not to try an update but I thought I'd try and find the cell and delete the problem rather than cover it up - if that makes sense.
6 Replies
Other places to look:
Formulas > Name Manager
The source range of charts
Can you click Break Link in the Edit Links dialog? that would solve the problem.
Thank you for the ideas. Name Manager does not give the results to the file. Break Link is greyed out so I cannot choose it.
- These are the places to check. Some of these have already been mentioned but here's all:
-formulas (Typically, you can break links in Edit Links if the external links are in formulas)
-named ranges
-the source of data validation drop menus
-objects with assigned macros pointing to external workbooks
If you believe you've removed all external links, it's worth closing/reopening the workbook. Sometimes the Edit links command won't dim out until the workbook is re-opened. If all else fails, you could re-name the .xlsx to .zip and delete the External Links folder.
