Finding missing links.

Y

y

I have the annoying problem to remove missed links.
Someone suggest to me Findlink.exe (I don't remenber the author, I apologize with him/her).

But installing it on my system it reports errors and it doesn't run correctly (it doesn't find out
missed links).

Could anyone of you show another tool, please?

Thank you very much in advance.
Alex.
 
P

Peter Huang

Hi Alex,

First of all, I would like to confirm my understanding of your issue.
From your description, I understand that you wants to delete some links.
Have I fully understood you? If there is anything I misunderstood, please
feel free to let me know.

XL: Delete Links Wizard Available
http://support.microsoft.com/?id=188449

Also you may try to take a look at the website below which give us the idea
about find link.
Eradicating Links - Part I
Eradicating Links - Part II
Eradicating Links - Part III
http://www.accountingadvisors.com/exceltips.php

Please apply my suggestion above and let me know if it helps resolve your
problem.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Y

y

Thanks Peter,
I installed dellinks.xla but it reports to me this error:

"Routine Location Error Code: 1"

If I deselect the component from the list I obtain this error

"Routine Location Error Code: 2"

What do they mean?
And how can I resolve the errors?

Another question: the readme file says I must close all the opened workbooks in order to launch
dellinks. But this way I can not access the utility.

Thanks Alex.
 
Y

y

Thanks Peter,
I installed dellinks.xla but it reports to me this error:

"Routine Location Error Code: 1"

If I deselect the component from the list I obtain this error

"Routine Location Error Code: 2"

What do they mean?
And how can I resolve the errors?

Another question: the readme file says I must close all the opened workbooks in order to launch
dellinks. But this way I can not access the utility.
I work on Excel 2000.

Thanks Alex.
 
P

Peter Huang

Hi Alex,

Since I can not reproduce the problem on my side, I suggest you take the
steps below to see if the problem persists.

1. Unload the wizard by going to Tools / Add-Ins and unchecking the Delete
Links Wizard
2. Close Excel
3. Reopen Excel
4. Go to Tools / Customize
5. Click on the Tools menu, then go to Wizard...,and if you see the Delete
Links entry, click and drag it onto the worksheet (effectively getting rid
of the menu item), then press OK
6. Then go to Tools / Add-Ins and recheck the Delete Links Wizard, close
then reopen Excel
7. If this doesn't work, go to Tools / Customize, and on the Toolbars tab
make sure that the Worksheet Menu Bar is highlighted and click the Reset
button
8. Then close, reopen and close Excel again to see if the error occurs.

Also you may try to use the delinks xla on another machine to see if the
problem persists, so that we can isolate the problem.

Also you may try to take a look at the link below which provide the macro
to do the things.
Macros to Delete Formula Links
http://support.microsoft.com/?id=126093


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
P

Peter Huang

Hi Alex,

Have you tried my suggestion?
If you still have any concern on this issue, please post here.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Y

y

Peter said:
Hi Alex,

Have you tried my suggestion?
If you still have any concern on this issue, please post here.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
Click to expand...

Sorry Peter, I solved manually the problem and disabled the add-in.
Maybe I'll try later. If there are problems I'll come back here.

Thanks, Alex.
 
Top