Permanently Remove "Update Links" Alert in Excel Workbooks

[@adventuresincre]

By the way. I use this trick about once a week - definitely worth using.

[@DaveHefty]

For the same document (where issue already solved) or each time for new documents? Thanks for the solution btw! Mine was conditional formatting problems.

[@carolruiz2012]

Omg! You saved me!! I’ve been working on a report for weeks and all of a sudden i couldn’t open the workbook without all the pop ups, you HELPED SO MUCH!! I love you!!

[@joannecoggins1133]

You saved me, man! I wrestled half the day trying to find the "missing link" that was messing me up. THANK YOU!!!!!!!!!!!!!!!

[@volumelow]

Same!! I spent 2 hours...and then this video saved me in 5 mins

[@dogodefrja]

Best explanation ever about solving this problem

[@usmanali7659]

It is a perfect explanation style & and enough for professional and nonprofessional workers. You did awesome work, You are great Spencer Buton.

[@seanoakes2964]

MY WORKBOOK IS SAVED! YOU CHAMPION! THANKYOUUUUUUU

[@eliamoussally1873]

Thank you very much for the perfect explanation , I had this issue for a while and couldn't find any useful article till I watched this video which fixed it in the first go. well done!!

[@innocentagada5422]

Thanks Spencer, I have been managing similar issues for long but your videos have helped to resolve those annoying pop-up

[@iftikharahmad3657]

Exactly what I was looking for. I have removed that annoying links first time after following your steps in conditional formatting. Thanks a lot.

[@danilocortez8133]

Thank you very much! This video helped to find out the annoying links when I opened my workbook. GREAT JOB!

[@Felipee85]

Step 3 with 'Name Manager' works for me, thank youuuuuuuuuu Sir!

[@psaa3799]

Hi Spencer. This vdo was very helpful. I have a question...What to do when the excel takes time to save file inspite having no external links

[@bimkumsen]

Thank you sir, appreciate all of your wisdom and resources offered so generously to excel community

[@ginarsmith120]

Excellent job! While my problem was something different than what you provided it helped me find my problem! My issue was the file was linked to a pull-down menu list I had defined using the Data Validation option. Once I directed the list to the correct location and restated Excel the problem was corrected.

[@rinmonimpak]

You are an unsung hero. Thanks! this video helps!

[@danryerson]

Great work. Missing data validation. That is where I found my issue.

[@AlexAlex-my2zo]

Thanks, this video is realy helping to solve my problems, Thank again Mr.Burton. Good advice, clearly voice & good explanation.

[@anthonyseifert567]

Best video out there on this specific issue! Spencer Burton, thank you so much!

[@falih60]

Thank you for this clip. It is very helpful and informative. It resolved my agony with this particular issue.

[@ytlmm]

Thanks, this is the only solution that worked for me!

[@manojchakerwarti]

Excellent Explanation

[@dianaaragon581]

Thank you it was very helpful!!!

[@standoutube7701]

Very helpful, it resolve my worksheet slow loading issue. All this while it is the Name Manager issues that causes the excel file take so long to open!

[@isaachaconr]

Thanks so much! This was a lifesaver!

[@dailymind]

Thank you so much... Perfectly explained.

[@traceylulu4860]

Thank you for sharing, it is very valuable.

[@vittoantonio5969]

I cleared all conditional formating but still can't break the links. Do you have an idea what else the problem could bed?

[@leewilliams3759]

thank you..so then can i assume if we went back to the Data tab, "Edit Links" would be greyed out?

[@guillaumepalayret7897]

All I needed, thank you!

[@marikosandoval5122]

Thanks for this video!!! Solved my problem!!!

[@volumelow]

You're honestly a life saver. Wow

[@mdsajjedhassenshaker9826]

Thanks

[@errrwth]

In the name manager if you have {...} in the Value column what exactly does that mean? No value is being returned? Trying to find out if its safe to delete a bunch of those in an old model without breaking it. Thanks!

[@mrwatcher1000]

Thank you bro, You just saved me with this video

[@cliffdeane9711]

Thank you, this "alert" has been driving me crazy.

[@John-bq9bj]

Lmao for real.

[@danielmensah7883]

Very helpful. Thanks a lot!

[@suzykeeping7332]

Hey! I am still getting a problem, i managed to follow your steps to get my "Break Link" button to come up (originally it was greyed out) but now when i click break link then it says "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You may be required to enter a password." But I have unprotected the sheet already?! PLEASE HELP.

[@adventuresincre]

Hey Suzy! Sorry to hear you're running into an issue here. Impossible to say exactly what's creating this issue, but here are a few suggestions: Check All Sheets: Make sure you've unprotected all the sheets in your workbook, not just the one you're currently working on. You can do this by right-clicking on each sheet tab and selecting "Unprotect Sheet." If a password is required, you'll need to enter it. Check Workbook Protection: Besides individual sheets, the entire workbook can also be protected. You should check if this is the case by going to Review > Protect Workbook. If the option to "Protect Workbook" is highlighted, that means your workbook is currently protected and you'll need to unprotect it. Check for Hidden Sheets: Your workbook may contain hidden sheets that could be protected. You can unhide these sheets by going to Home > Format > Hide & Unhide > Unhide Sheet. Once any hidden sheets are visible, make sure these are also unprotected. Check for VBA Project Protection: If your workbook contains VBA code, the VBA project could also be protected. To unprotect it, you would need to open the VBA editor (Alt + F11), select the project, then go to Tools > VBAProject Properties > Protection and uncheck the box that says "Lock project for viewing." Save and Reopen the Workbook: After making these changes, save and then close and reopen your workbook. This can sometimes resolve issues with lingering protections. If these steps don't work, it's possible that there's an issue with the workbook itself. You might want to try copying your data to a new workbook. If the problem persists, you may need to reach out to Microsoft Support for further assistance.

[@EdwinDXB]

Thanks. It works fine now. :)

[@jimhockey4374]

Excellent thanks.

[@soumyamukhopadhyay6293]

Great video it helps me a lot

[@siteshsharma5955]

very helpful thanks a lot

[@2020DayTrader]

Thank you. That worked great.

[@Mish2025]

will the file owner of the other excel files, be notified of you break the links?

[@adventuresincre]

No

[@kriss1616]

Nice one thank you

[@basitrasheed3806]

i have checked in cells, conditional formating but could get rid of these links

[@yankeepapa4497]

THANK YOU VERY MUCH.. I LIKE I LOVE .. ❤❤ FROM INDONESIA 🇮🇩

[@blanemeyer3023]

thanks for the help

[@ahndeux]

There is a much easier way to turn off the warnings immediately. First, customize your ribbon to display the "Developer" tab (right click on the ribbon and choose "customize the ribbon". On the right hand side, put a check mark on the "Developer" tab to display it.) Click on the "Developer" tab and click on the "Visual Basic" button. Click on the "View" tab and choose "Properties Window" (Or just press F4 button). Click on the "ThisWorkbook" on the project list. On the second to the bottom, there is an option for "UpdateRemoteReferences" set that to "False" and set the "UpdateLinks" to "2 - xlUpdateLinksNever". Save the workbook and you will never get those warnings again on this particular sheet. You can go through the steps on this video to clean things out, but sometimes, its nearly impossible on complex sheets.

[@hsgusain2054]

THANKS .... same problem i was facing....

[@RobinHood-yj3bs]

hey buddy. hope you are doing fine. good tricks.

[@cananpasa5623]

Thank you 👍😊

[@lalitlodaya6126]

Have you made any video on "some files contain viruses or otherwise be harmful to your computer".

[@Mark_Lacey]

Great thanks!

[@ionutdobras7129]

Thank you!!!

[@emadfathy685]

Thank you

[@mohamedaboobackersiddique7322]

Thanks a million!

[@alexandra4873_]

Any help for when your name manager won’t open? 😢

[@adventuresincre]

Hmmm - never encountered that issue! Found a coule of threads where someone had a similar issue. Not sure it's helpful, but thought I'd share: www.mrexcel.com/board/threads/name-manager-not-opening-macros-not-working-to-fix.1209192/ and www.mrexcel.com/board/threads/name-manager-does-not-open.1066423/

[@richardrichard5816]

Thanks, I couldn't work with that error, I thought there was no point in working more on that error.

[@inleesuhslife]

Thank you, so much!

[@sohammultitech9667]

thnx ... very useful

[@SyedAounAbbasZaidi]

I have no outside link what about that

[@shielamaepono2437]

What will happen if you save the file after you break the links?

[@matlholelosaba4977]

Saved a copy of the linked Excel file onto a USB with a different name. Deleted all the worksheets in the linked Excel files. Saved and closed the file. Opened the Excel file with the links. Went Data ==> Edit Links ==> Open Source File. I guess Excel looked for the references in the now empty Workbook and found none. This seemed to work perfectly for me.

[@sanjuansteve]

Thx dude

[@vishalsharma3988]

Thanks bro

[@jaiswansekaran6028]

Thanks ..

[@apidraiceboy305]

What if i want to update it but i want it automatically? How would i do that?

[@ahndeux]

See my explanation on how to change the workbook properties by opening the Visual Basic Properties for the excel file, but change the "UpdateLinks" property to "3 - xlUpdateLinksAlways". That will automatically update the links every time you open.

[@mikelennon1078]

Excel 2019 how to delete all existing tables within in a workbook with all of their tables names , all together without loosing data?

[@TremainSr]

I did everything and I still didn’t resolve my issue 😔😞…. It was explained well in detail but something else is clearly not working.

[@maxdragich3036]

How do you recover the data deleted if you accidentally clicked the “update”?

[@Sedic_Namsu]

Don't know about you guys but if you want to disable the automatic update link notification, go to FILE tab, then click on INFO, under Security warning click on Trust Center Settings, then click on Never show information about blocked content. Click OK and you're done

[@tutorialyoutube2024_KangUji]

❤️

[@gurudyakhalsa4594]

These TIPS work for PC, but not for MAC EXCEL. How do you do this for EXCEL for MAC USERS

[@picturamusica-musicalpaint1074]

still CANNOT BREAK LINK

[@subashguleria]

Thank you, it's really helpful,👍

[@sivangrinberg9050]

Thank you very much!!

[@ADELALWAILY]

Thank you