How to edit Excel Links, Excel Can't update Links Error

You are amazing, thank you!!!!!

Is there a way to remove all external links (including links in other sheets within the same workbook) with 1 click? Is there a macro to do it?

Thank you

Thank you for the help! You can also change the Search option to "Workbook" so you do not need to check it on each Sheet.

Thank you for this breakdown. In my case i just made a copy just in case, verified the links if serious, and broke the links. It worked. Subscribed