Somehow, the worksheet has external links to files that are no longer around. How can we delete the links?
Ans) This happens all of the time to MrExcel. I downloaded a little macro from Microsoft which helps you remove these links. Microsoft has now upgraded the macro to a full blown add-i.