Forum Discussion

Wendy Goeminne's avatar
Wendy Goeminne
Copper Contributor
Mar 21, 2017

"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...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 21, 2017

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

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 25, 2017

I use Spreadsheet Compare 2016 from Office 2016 package. Quite often (but not always) it helps

- save file with another name

- break links in it

- compare with above tool initial and latest files

 

it shows the difference  cell by cell

Resources