Finding invalid link

  • Thread starter Thread starter Michelle
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding one or more "Invalid References" in big spreadsheet 1
How to create absolue path link to another workbook (Excel 2003) 1
Link To File That No Longer Exists 1
Breaking links leaving invalid reference #REF! in cell 1
Formula with Invalid References Error Message 5
Invalid references in a formulas 3
Compile Error help 2
how do i locate the cell linking to another spreadsheet 2

Back
Top