Finding References of Broken Links

**Jenn68** · 06-10-2012, 07:58 AM

When opening my workbook, I keep getting reminded that I have a broken link to another data source.

I've reviewed all my names, and have used the "find" feature (workbook and in formulas) to find where the reference is. But I can't find it with these methods.

Has anyone any advice or tricks on how I can find this reference? I realize I can disable this prompt, but prefer to fix the problem than ignore it.

**dilipandey** · 06-10-2012, 08:15 AM

Hi Jenn68,

Press Alt + E + K and see the window.. If there are few links, you can click on open source / update to check if they are working.. if any link is not updating, you can fix them .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>