Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Cancel a Link and a Macro | Excel Discussion (Misc queries) | |||
assemble link from different cells and return value | Excel Worksheet Functions | |||
Link Link Link | Excel Discussion (Misc queries) | |||
Breaking the link | New Users to Excel |