I am having an issue with my Excel 2010 workbook that is extremely frustrating.
When I open my workbook, I am getting a "This workbook contains one or more links that can't be updated" message. I started getting this after I accidently deleted a worksheet and replaced it with a backup copy.
When I use the Edit Links feature, it shows the file and location causing the "Error: Source not found." broken link.
I managed to find the offenders ... references amongst different named ranges.
The problem is ... I see the offending references in the Name Manager, but all options to do anything are greyed out. I can't edit, or delete, or anything with that particular name in an effort to resolve the bad link.
What do I need to do to gain access to edit this name?
If it matters, this particular name is listed several times but each referring to different workbook scopes. Of the numerous entries, one is valid.
Jenn
Bookmarks