Finding invalid link

M

Michelle

I have a big spreadsheet that has a link to a file that no
longer exists. How can I locate the cell(s) that contains
the invalid link? I tried the FIND function using 'look
in formulas' and it was unable to locate the cell(s).

Thanks in advace,
Michelle
 
J

Jim

Is it important to find the linked cell? If not, Edit>Links and change the
link to the file itself. You may also Insert>Name>Create>look for a name
reference that refers to #REF! and delete the name. Thwere is also a free
download addin named findlink.xla. You may Google for it or perhaps someone
will post the link to it.
 
Top