Forum Discussion
"Ghost links" in excel
Dear all, I have a link in my excel (visible in data/edit links) but I cannot find in which cell this link exists. I have already tried to search for it with Ctrl F, but no result. If I try to re...
Hi Wendy
Possible ways to look for links in workbooks
- Search for file types (e.g. xls, xlsx, xlsm).
- Name Manager
- Conditional formatting (>= XL2010)
- Data validation (>= XL2010)
Links:
http://blog.contextures.com/archives/2013/11/12/find-external-links-in-an-excel-file/
http://www.exceldashboardtemplates.com/how-to-fix-security-links-warnings-in-an-excel-spreadsheet/
http://nhsexcel.com/how-to-break-resistant-external-links-in-excel/
http://superuser.com/questions/915270/force-external-link-in-excel-to-break-if-the-file-cant-be-found
http://www.manville.org.uk/software/findlink.htm