Deleted link
 

I have a spreadsheet with a link to a deleted file in it, obviously every
time the spreadsheet is opened it tries to update the link. Is there a way
to find which cell or cells are trying to get the information from the
spreadsheet that no longer exists?

It's just an annoyance! But I'm not the only one to use the spreadsheet!

Thanks in advance

Dean

--

http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso

Try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Dkso" wrote in message
...
I have a spreadsheet with a link to a deleted file in it, obviously every
time the spreadsheet is opened it tries to update the link. Is there a way
to find which cell or cells are trying to get the information from the
spreadsheet that no longer exists?

It's just an annoyance! But I'm not the only one to use the spreadsheet!

Thanks in advance

Dean

--

http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso

Hi Dean,

Try Bill Manville's FindLink addin which is freely downloadable at:


http://www.oaltd.co.uk/MVP/Default.htm


---
Regards,
Norman



"Dkso" wrote in message
...
I have a spreadsheet with a link to a deleted file in it, obviously every
time the spreadsheet is opened it tries to update the link. Is there a way
to find which cell or cells are trying to get the information from the
spreadsheet that no longer exists?

It's just an annoyance! But I'm not the only one to use the spreadsheet!

Thanks in advance

Dean

--

http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso