I have a huge spreadsheet, after some copying and pasting from other documents I see the warning that there is a hyperlink to another spreadsheet on every time i open the file. While this does no damage, I want my collegues to work with the thing without seeing an error message every time the open the tool.
Now, when i choose data -> edit links (or similiar, I'm working on a german version excel) I see one link to another file, I choose "delete link" and nothing happens. Meaning: The link is still displayed, I still get the warning. I try to make the external source point to the actual file I'm working on, I get an error message that the link does not work.
I want to work on the cell directly that conains the offending link, how can I find it? The spreadsheet is large and contains many sheets. Is there a tool or function that can help me here?
Any other ideas on how to solve this?