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 tryi...
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.- Thank you Hans and Patrick for the help. So here is what happened.
Nothing was working so I went for a brute force solution. There were 3 tabs so I deleted each one in turn and found out which tab had the problem. Once I determined the tab I started looking at the sheet. This tab had a chart so I deleted the chart and the problem went away. So I am getting close.
The chart was pulling data right off the same sheet. As I dug into the chart I discovered the axis labels were pulling from the dead/gone file and that was causing the error. The funny part is the labels it was trying to call from the old file are on the current sheet. So I updated the axis label to pull from the sheet and voila - fixed.
If you wish, you can attach the workbook to a reply or make it available through OneDrive, Google Drive, Dropbox or similar.
