MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding external links

Posted by Paul on October 18, 2001 2:56 AM

When I try and save a template I get " this workbook contains external data. Do you want to clear the data before saving the template, and the automatically refresh the data whenever the template is opened?" I have not linked to any external data, that I know of, how do I check to see if there is a link, and how do I delete it? I am using Excel '97 Thanks

Posted by Dwight on October 18, 2001 5:19 AM

Hope this helps

If the worksheet contains links, you can see the source file(s) by selecting "Edit, Links" from the main menu. I don't see a way from the reulting dialogue box to know which cells contain the links, but you could then select your entire worksheet and hit Ctrl and F simultaneously and use the resulting "Find what?" box to locate the links to the files shown as sources.

Maybe there's an easier way, but this should do the trick.

Posted by MrExcel on October 18, 2001 6:50 AM

External links can be maddening. Microsoft offers a free tool to find and delete them. Just yesterday in the Tip of the Day section, I posted a review of a German guru's program to remove links. Check the October 16 & 17th postings at

Posted by IML on October 18, 2001 6:59 AM

Is just me, or are other people not able to access this link (either from here or the home page?)
By the way Mr. Excel, I love the tip of the day idea.

Posted by IML on October 18, 2001 7:05 AM

Its my browser, false alarm.

Posted by Paul on October 18, 2001 8:11 AM

Thanks the addin find links in the workbook but all of them were link that I know about, the message said this workbook contains external data, is this the same as a link? Also thanks for the tip of the day section.