Have a look for links in Defined Names.


Gord Dibben MS Excel MVP

On Fri, 8 Apr 2011 05:38:11 -0700 (PDT), TheMilkGuy
wrote:

Hi folks, as the subject says I'm at my wits end with regards to
automatic linking.

I am using sheets from an old workbook in a new workbook and I can't
seem to find any more external links to delete, yet Excel 2010 still
gives me the yellow ribbon that says "Automatic update of links has
been disabled" on startup.

I have searched for [ and ], c:\, ref, name, value... Can't seem to
find the culprit.

Can anyone lend a hand? I have to distribute this file and I don't
want that ribbon showing up for everyone.

Thanks,
Craig