View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I get rid of expired links

Could be part of a defined name.

Have a look in InsertNameDefine


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 09:49:04 -0800, Dave Schreffler
wrote:

I have a [Excel 2000] spreadsheet that shows a link to another spreadsheet in
Edit/Links. However, I can't find any cell in the spreadsheet that accesses
the spreadsheet listed in the link. Also, if I click on the link in
Edit/Links, the Update Now is grayed out.

How can I delete this link? Whenever I open the spreadsheet, I am asked if I
want to update the link, then told Excel can't find it.

Thanks,