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
I've experience of such when there are name range setting contain reference from other file. Use 'Defined Names' functions under 'Formulas' tab and check if there are range name addressed from other files.
Regards
Claudia
Names Manager was the trick I was looking for! Thanks Claudia from 4 years ago! I had a host of buried link references in the names manager....and they were not visible anywhere else on the sheet.