Remove link!

[Danny]

Is there a way to remove links (VBA or otherwise)? I know
that my spreadsheet is no longer linked to another
worksheet but when you click link, the "Source File" still
bears the name of the previous source. How can I delete
the NON-Existing link?

Thanks.

 

[John Wilson]

Danny,

Maybe a "phantom" link.
Take a look here for some help.

http://j-walk.com/ss/excel/usertips/tip054.htm

Another option would be to download this Add-In
from Bill Manville:

http://www.bmsltd.co.uk/mvp/

John

 

[Danny]

John,
Thanks for the tip. Have a nice day.
Danny

-----Original Message-----
Danny,

Maybe a "phantom" link.
Take a look here for some help.

http://j-walk.com/ss/excel/usertips/tip054.htm

Another option would be to download this Add-In
from Bill Manville:

http://www.bmsltd.co.uk/mvp/

John




.

 

[Danny]

The instructions here worked Michelle.

http://j-walk.com/ss/excel/usertips/tip054.htm