Unwanted Links

Sourdust

Well-known Member
Joined
Sep 15, 2002
Messages
769
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
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Bisleycat2002

New Member
Joined
Sep 17, 2002
Messages
41
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

Well-known Member
Joined
Sep 15, 2002
Messages
769
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.
 

Sourdust

Well-known Member
Joined
Sep 15, 2002
Messages
769
Thank you very much Mark. Another solution to a problem I have this forum to thank for :)
Sourdust
 

Forum statistics

Threads
1,144,436
Messages
5,724,343
Members
422,545
Latest member
zillafreak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top