Finding a problem link in Excel!

T

Tracy B.

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?
 
C

Carey Frisch [MVP]

Please repost your question in the Excel newsgroup:
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

--
Carey Frisch
Microsoft MVP
Windows - Shell/User
Microsoft Community Newsgroups
news://msnews.microsoft.com/

---------------------------------------------------------------------------­----------------

:

| 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?
| --
| Tracy B.
 
Top