Why can't I kill the Excel External Links?

[@crushingit5128]

Going to Formulas and then Name Manager solved my issues. And this was something Ive been struggling with for probably like 6 years in my career. Thank you so much.

[@StrategizeFinancialModelling]

Happy we could help!

[@agfinco]

Name manager approach saved my life, thank so much!!!

[@BlackBird-th9ib]

Awesome! Thank you so much! I couldn't break an "unbreakable" link until I viewed this video

[@weikel]

One thing to add to your list would be data validation (dropdowns) linked to an external sheet. Usually you wont be able to open up the dropdown when this is the case and will need to delete or relink the data validation.

[@StrategizeFinancialModelling]

Thanks Tyler great call! This is certainly another source, which can prevent users from killing external links. Stay healthy,

[@riverfu889]

I have a very small model that inherited a couple worksheets from other files, and it became 4M for no reason, and file size won't shrink even if I delete all worksheets. I can see a link under Data but cannot break it. After viewing this video, I went into name manager and found hundreds if not thousands of names linking to external database. Deleting those results in a 40K file size. Feeling much better now and thanks for this video!

[@StrategizeFinancialModelling]

It's our pleasure River, happy the video helped. Further, if you save the file as a binary file format (.xlsb) that will further shrink the size of the file by up to 70%, whilst preserving formats, macros etc. Simon, Strategize Financial Modelling

[@see8791]

Awesome! Thank you so much! I couldn't break an "unbreakable" link until I viewed this video. The links that I could not break were tied to other workbooks. Following the path to: Formulas->Name Manager, was the answer to breaking the link reference. I never knew that existed until now. Thank you, thank you, thank you!!!

[@StrategizeFinancialModelling]

It's our pleasure! Thanks for the feedback. Strategize Financial Modelling

[@noblestride]

Thanks a billion trillion and everything! Thank God clicked your link.. The problem finally solved!

[@StrategizeFinancialModelling]

happy we could help!

[@simontatarenko5580]

Does this work for cell referencing in accounts when working with multiple excel sheets?

[@StrategizeFinancialModelling]

Yes it should @Simon Tatarenko

[@catdog5830]

Very helpful! solve my problem in 5 sec! Thank you!

[@ngomusacherncy8432]

Aw ThAnk u So much i had stubborn ones the Name manager trick i didnt know!

[@muhasina123]

If the file was created in 2016 and later file is opened is 2013, then external link will be prompted and the file will not work. Opening the file in Excel 2016 will solve the issue

[@huztin1]

Hello ! I see the links in "edit links" but i cant see, to break it, please help

[@StrategizeFinancialModelling]

Hi Huzefa, thanks for your post. Did you go through the video again? Is it possible the undeletable external link is something innocuous like picture, table or image, which someone has pasted into the workbook in question? Let us know

[@lynnettedillon4885]

Fantastic video. I was mystified by an external link I couldn't find but thanks to your video it is now gone. It was in a named range.

[@StrategizeFinancialModelling]

Thanks Lynnette!

[@billfowler4547]

When I break a link as described in your first scenario, it doesn't do anything. Well, it laughs at me first, but then doesn't do anything. Nice video, though.

[@StrategizeFinancialModelling]

Hi Bill thanks for the feedback. Does you spreadsheet contain any special objects like logos etc? Let me know, happy to help you troubleshoot it for you. regards Simon

[@billfowler4547]

@@StrategizeFinancialModelling Actually, I had carelessly copied a cell from another spreadsheet (containing text) on Teams to this worksheet and I think it created a link probably because I just used paste rather than paste special values. Anyway, I fixed it by re-copying it. Thanks, I appreciate your offer to help. Bill

[@StrategizeFinancialModelling]

It's our pleasure Bill, feel free to reach out if you have any further questions. regards Simon

[@deanshaw6416]

Finally, thanks for this

[@StrategizeFinancialModelling]

Our pleasure Dean!

[@txmoon5004]

Thank you, excellent video but none of those suggestions worked.

[@StrategizeFinancialModelling]

Hi TX Moon, what types of features does your spreadsheet contain, which is preventing you from killing the external links?

[@TheFeralBachelor]

@@StrategizeFinancialModelling It was a link to a back up file and I could never find where it was embedded. Titles, charts, tables, formulas, nothing. I ended up saving back to an .xls file. Then opening that which didn't have the link and "saved as" an .xlsx file and overwrote the original file. All is well now.

[@izhar899]

@@TheFeralBachelor Thanks. It really worked for me. I was working on this issue for last 3 days.

[@atan0404]

@@TheFeralBachelor thanks a mil! this worked for me as well. lifesaver!

[@jujucastaneda1945]

This is a great help!

[@SeeEssPerez]

Helpful vid. Thank you!

[@StrategizeFinancialModelling]

Glad you enjoyed it!

[@VishalKumar-qz8oy]

Sir edit link does not work (disable) Please solve my problem 😥😥

[@StrategizeFinancialModelling]

Hi Vishal you most likely need to enable edit links at the top of the workbook

[@zeadaniella7000]

this is a great help.. Thank you..

[@lmarwarl]

Thank you man!

[@StrategizeFinancialModelling]

Happy to help Marcelo

[@samanalvand2263]

Thanks