Unwanted Links

[Sourdust]

Sorry if this is a bit simple but can anybody suggest a way to help me find a cell with an unwanted link without having to scroll through cells looking for it? I use a particular set of spreadsheets on an annual basis and simply change the data in the previous years and rename them as the current year. Even although I think I have been careful to overwrite all cells with formulas in them I still see the link to last years files in Edit Links and have to scroll through worksheet after worksheet and cell after cell before I find the unwanted link. Often in a cell I have used for calculation for the main body of the report and forgotten about
My aching mouse finger would greatly appreciate your help.
Sourdust

 

[Bisleycat2002]

I had this question myself yesterday - the simplest and best answer then was use Edit-Find and search for .xls or [ and then Find next etc

 

[Sourdust]

Much appreciated Bisley. I was hoping there was a command to find cells with a defined link but who said the world was perfect never mind Microsoft. Your suggestion will certainly speed things up
Sourdust.

 

[Mark W.]

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q188449

 

[Sourdust]

Thank you very much Mark. Another solution to a problem I have this forum to thank for
Sourdust