Aug 15 2018 01:27 AM - edited Aug 15 2018 02:57 AM
Aug 15 2018 01:27 AM - edited Aug 15 2018 02:57 AM
When I open my Excel file I get notified that a file, that is currently of no use and not intentionally linked in - cannot be found. The pop-up says:
"Sorry, we couldn't find <URL to file>. Is it possible it was moved, renamed or deleted?"
I have tried to use Edit Links... and even Break Link, but the error does not go away.
Clearly, there is a reference to a file somewhere, but I cannot see where. Going to File/Data/Edit Links brings up the same file reference, but still no clue as to where they are embedded. I have used Name Manager to check for embedded references in names to no avail. Also no objects where it could hide. I have used the Find function to look for references in formulas and values...
Does anybody have a suggestion ?
UPDATE / SOLVED
I finally discovered that the document reference was hiding within a Data Validation reference. Excel does not provide much help in finding the cause....
Aug 15 2018 04:27 AM
Good job hunting that out!
Aug 15 2018 05:52 AM
You might consider voting for this idea.
Aug 16 2018 02:15 PM
SolutionThat idea is under review from 2015, who knows how many more years it takes to implement. At the same time FINDLINK works fine for a long while.
Jun 15 2022 09:47 PM
Jun 16 2022 11:23 AM
That thanks to developers of this tool.
Aug 16 2018 02:15 PM
SolutionThat idea is under review from 2015, who knows how many more years it takes to implement. At the same time FINDLINK works fine for a long while.