View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Link To File That No Longer Exists

I am using Excel 2007 for Windows.

Every time that I open this one spreadsheet I get a warning window
stating that the workbook contains one or more links that cannot be
updated.

Clicking on the window's Edit Links button shows that there is a link
somewhere to a source file that no longer exists. (The file was
deleted months ago as it was no longer needed.)

The problem that I have is finding where in my workbook is the linkage
to this file. My workbook has many tabs. I know the name of the file
that no longer exists so I opened each tab and used the cursor to go
over each cell with formulas trying to find the linkage but so far no
luck.

How do I find where this link is located in the workbook?
--
tb