Invalid Link in Excel

I have this annoying link somewhere in an inherited spreadsheet. The link tries to update everytime the file opens and generates the “Can’t find file” error.
I need to leave “automatically update links” on.
How can I find the cell that contains the faulty link? The spreadsheet is complex and I haven’t been able to find it.