View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Debbie Hatten Debbie Hatten is offline
external usenet poster
 
Posts: 1
Default Find Linked Cells

Anyone know of a way to scan all Excel files in a drive to
find out if they have external links?

The issue is that our drive mappings are about to change
so a cell that contains a link to T:\workbook.xls should
now be pointing to G:\workbook.xls. I would like to be
able to scan all network drives for any Excel files that
contain linked cells so that I do not have to open each
one individually and go through Edit-Links to find them.
Is this possible or am I dreaming?

Thanks!