[Solved] Find and remove all links

[fred987]

I created a 52 page sheet many years ago with links all over the place including quite a few imported tables ( also with links) from a website then I stopped using it for a couple years. Now I'm trying to use it again and every time it opens I get an opening box to "update all links" followed by "this file contains links to other files, should they be updated". If I choose No to each of theses things are fine, if I choose yes the sheets get really screwed up. I dont need any of the links and I've gone though and deleted everything I could see/find but I still get the messages.

Is there a way to just delete All links in bulk not knowing where they are?

[Zizi64]

Please upload your .ods type sample file here.

[Hagar Delest]

Hi and welcome to the forum!

Try the menu Edit > Links. Then select them all and break the links with the button the right.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.

[fred987]

Thanks Hagar! I knew it had to be simple.