Software

Ask something
Discussion Locked

Invalid Link in Excel

0 helpful
6 replies

by tom_sellin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have this annoying link somewhere in an inherited spreadsheet. The link tries to update everytime the file opens and generates the "Can't find file" error.
I need to leave "automatically update links" on.
How can I find the cell that contains the faulty link? The spreadsheet is complex and I haven't been able to find it.

6 replies

by Ryan Boudreaux140

If the error message is giving you the name of the file that it is attempting to link to then make sure that the linked file is accessible. Also, if you could run a Find on that file name within the spreadsheet to locate any instances that might be contained within cells.

Hope this helps!
ET

by tom_sellin

The file that the link is looking for is not on our server. The excel spreadsheet came to me by mail.
The link has to be removed.

by tom_sellin

The file the link is looking for is not on our server and the link is no longer required.
My goal is to remove the link completely...If I can find the cell.

by ann777

Go to Sheet1 of the worksheet (first tab in the lower left corner) ... and hit Edit --> Find --> and enter the filename that the computer cannot find (or any part of the filename).

I think you will need to go through each sheet (page) of the spreadsheet that is generating this error.

This discussion is closed to new replies.