- This Weeks 'Excel Help!!' thread :-(
Somehow a link to a non-existent file has been added to my workbook. Lots of Googling later and I now know the name of the linked file, but cannot find the cell(s) which contains the link
I have tried searching for parts of the filename and the [ , but neither gives any results
I found a link to a wizard on an MS Support page that offers to get rid of these type of links, but it is obviously for an older version of excel and does not work
I could just ‘break the link’ and pray it does not impact anything (scary)
Can anyone give me any pointers
Pretty please 🙁Posted 5 years agotwicewithchipsMember
Is the link on a hidden sheet?
Any protection on the workbook?
what about the linked file – does the context of the data there give any clues?
If I remember rightly, breaking the link will leave you with the last values that were linked (so changes to the formerly linked file no longer have any effect). If it’s your mileage claim this is obviously less of a problem than if the data includes the launch codes…Posted 5 years agobenp1Subscriber
What version of excel are you running?Posted 5 years ago
I should not have any hidden sheets (will check though) and I have not yet added any protection to the workbook (maybe I should have done before I asked someone else to do some updates…..)
In terms of importance, it’s somewhere between a mileage for and the launch codes :wink:, but I could be up for a lot of hassle at work if I get it wrong 🙁Posted 5 years ago
There is a macro you can run to find all links, it’s on this page:
NB If you’re really stuck you can email me the workbook and I’ll find them for you….Posted 5 years ago
Thanks Chaps. A combination of comments from above meant I found that the problem is in the ‘data validation’ rather than in the cell itself (hence the search did not work).
I have just deleted all data validation which removes the error/links. Now I just need to recreate the data validation again which is a lot better than what I was hopingPosted 5 years ago
The topic ‘This Weeks 'Excel Help!!' thread :-(’ is closed to new replies.