Hi,

Your welcome!

You need to be in the file where the link resides not the target file to
which you are linked. The follow Benjamin's suggestion Edit, Links, select
the link and click Break Link. In 2007 the command is Data, Edit Links,...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"brosull" wrote:

how do I break an excel link to another worksheet when "Break Link" work?

Thanks to Shane for replying.