Break Links Not Working in Excel 🔗

In this video, we see how to break links in Excel when the Break Link button is not working.
When Using formulas in Excel and then copying sheets and creating additional versions of files. Over time we can end up with redundant links. Normally these can be removed by clicking Break Link in the Edit Links dialog.
Sometimes Break Link does not work. This video provides a solution.
The timings of the video.
00:00 - Introduction to break links in Excel
00:12 - Links cannot be updated message
01:24 - Break Link not working
02:49 - Finding the external links
04:59 - Break links to external workbooks
06:12 - Test if the external links exist
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Facebook ► / computergaga
Twitter ► / computergaga1

[@BabsiRW]

This is so revealing and incredible helpful !!! Thank you sooo much !!! What a relief to get finally rid of those strange "ghost" links ! In the Name manager I couldn't delete some ranges (greyed out). But going through the different sheets and with "Find and select" I found the broken data validations and was finally able to fix them. Again: THANK YOU !!!

[@Computergaga]

Awesome! No problem

[@Cala_Lilly]

Thank you so much! Google was no help, but your video was :-)

[@Computergaga]

Glad it helped!

[@ektakhippal9559]

great video. thanks! It solved my issue. :)

[@Computergaga]

Brilliant! That is what I like to hear 😊

[@jackybaylis9456]

thank you very much for the complete walk through and no tunes!!...well done 👏👏👏

[@chichipio2]

Thanks! I was going in circles for about an hour with this problem!

[@Computergaga]

Glad I could help! You're welcome.

[@DjLufthanza]

Thanks for solving my problem!
I had broken links to C./Windows/System32 folder wich was kind of anoying...
I did not know that the conditional formatting aslo could have broken links, but thanks to you I finaly found them :)

[@kelvinissh]

Wow! That was very helpful. Thank you

[@Computergaga]

Great to hear. You're welcome, Kelvin.

[@sircorn4248]

I have found this video very useful. These hidden links have been driving me nuts.

[@Computergaga]

👍

[@marciodasilva6920]

You saved my day, thx.

[@Computergaga]

You are welcome!

[@shoaibrehman9988]

Very common scenario in daily routine i will definitely use your method thanks Allan to share with us.

[@Computergaga]

Thanks Shoaib.

[@juansebastianrodriguezpime3477]

Great tip thank you!😉

[@Computergaga]

My pleasure. Thanks!

[@vincentcoltier3786]

Perfect! We were losing our mind on some request for ghost passwords....

[@Computergaga]

😊

[@markpodesta4605]

Thank you Alan. Will give it a try.

[@Computergaga]

Thanks, Mark.

[@Sachin19831000]

Thanks for valuable information 😊👍🏻

[@Computergaga]

My pleasure 😊

[@chikaaudreyna3916]

Thank you so much this is very helpful

[@Computergaga]

You're very welcome!

[@ravisiripuram4654]

Found it helfful, thank you!

[@Computergaga]

Great! You're welcome, Ravi.

[@cheungagnes8086]

solved problems, thank you so much

[@Computergaga]

My pleasure!

[@thefceUSMC]

Awesome video. Break links was driving me crazy.

[@Computergaga]

Thanks, Chad 👍

[@catherinenorth8353]

Me too! Thanks Alan 😊

[@mmmchamp9292]

Great useful video

[@Computergaga]

Thank you. Very glad it was useful.

[@mdsaim475]

thanks it's working

[@Computergaga]

Excellent!

[@RJ_331]

So, basically, just delete all the conditional and data validation 😂😂😂. Fml. It worked though! Thanks for the video!

[@Computergaga]

😂 No worries!

[@051_iqbalghazimaulana4]

i love u bro

[@Computergaga]

Love you too

[@teoxengineer]

is there any way to remove them by using VBA?

[@Computergaga]

Sure. Locating them I guess would be the issue.

[@mon_rich5366]

can you merge course in udemy for me to become affordable i mean buddle all cost in 1

[@Computergaga]

Udemy do many promotions on the courses including additional discounts for specific countries.

[@ScottSennheiser]

name manager window won't open

[@cristiano6075]

Cool Thank you

[@Computergaga]

You're welcome, Cristiano.