Finding a Problem Link in Excel

[Guest]

I have an Excel worksheet that has a link I can't find. When I run the Find
Links option it gives me the name of the link but no worksheet name. When I
select "Yes" to delete the link I get this error message:

"SORRY, AN UNEXPECTED ERROR HAS OCCURRED IN STAGE NAMES OF FIND LINKS. ERROR
1004: THAT NAME IS NOT VALID".

If I select "RETRY" I just keep getting the same selection, "RETRY". If I
select "ABORT", the Find Link action is aborted. If I select "IGNORE" it
goes to the next link and ignores my problem link.

When I ask Links to List all the Links it lists all my links (398!) and
shows this one problem link as well but it doesn't show any worksheet name
under the column "Worksheet", as all my other links do.

Can anyone tell me how I can get rid of this problem link?

 

[Dave Peterson]

Are you using Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Bill's email address is on that page if you want to contact him directly. If it
is a chance to enhance his program, I bet he'd welcome the notice.

 

[Guest]

I FOUND THE SOLUTION!! The key was in the Error Message, that said the error
was in stage NAMES. I searched through my tool bar and under "INSERT" I
located "NAMES". I selected "DEFINE" and there I found my corrupted link.
It had been introduced to my workbook by importing a worksheet from another
file. I deleted that NAME and my workbook is now clean again.

GOOD TO KNOW!

 

[Dave Peterson]

You may want to get Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much, much easier.