Forum Discussion
Wendy Goeminne
Mar 21, 2017Copper Contributor
"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...
Brock1895
Nov 23, 2021Copper Contributor
This may have been covered by someone else but I didn't see it covered so I'll mention:
I had a ghost link that turned out to be a macro from an old workbook. I must have copied over an object from that old workbook (linked to run a macro within the old workbook). In the new workbook it was trying to find the macro from the old workbook (but the old workbook had been subsequently moved). To correct the issue I simply changed the macro linked to that object to a macro that actually existed in the new workbook.