title: deleted names in a Wbk still exist and refer to locations that don't exist, slow Excel
body: <p>In VBA Help for the RefersTo Property, they give this  example of listing all the Names in a Wkb (fleshed out so you can run it as is)</p>
  
  <pre><code> Sub showNames()'from VBA Help for "RefersTo"
     Dim newSheet As Worksheet
     Set newSheet = Worksheets.Add
     Dim i As Long, nm As Name
     i = 1
     For Each nm In ActiveWorkbook.Names
       newSheet.Cells(i, 1).Value = nm.Name
       newSheet.Cells(i, 2).Value = "'" &amp; nm.RefersTo
       i = i + 1
     Next
     newSheet.Columns("A:B").AutoFit
   End Sub
  </code></pre>
  
  <p>When I run that on my current project, it turns up many Names that I thought were long gone.  But here they are still hanging around and referring to places that no longer exist.  I think this is what's slowing up my system and I'd love to get rid of those Names, but they don't show up in the Define Name window so where do I find them?</p>
  
  <p>edit: Meant to mention that the Links item is greyed out for this Wbk.</p>