Get instant live expert help on How do I break links in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I need your help breaking the links in my workbook. I go to data + edit links and do break but it doesn't break! Also before doing this I would like to check on the formulas that have these links! I've searched in the workbook through formulas .xl but excel displays it can't find it
Solved by D. B. in 12 mins
Can't break links. Have checked conditional formatting, data validation, name manager and hidden cells but still no luck
Solved by T. S. in 13 mins
So i kept getting links disabled links to external workbooks are not supported and have been disabled, after i tried to break them and re upload the spreadsheet into sharepoint i then got a file corrupt error
Solved by B. U. in 13 mins
I have an Excel file that, when opened, said it is unable to open certain files that are linked to my file. However, my file contains absolutely zero links that I use. I am unsure where these links exist in the file but when I go to edit links and break them, nothing happens. I believe that the file I am using started as template that may have used links and perhaps that is why that prompt exists but the file I current work in does not use any links and I should not be getting prompted about links when I open it like when it says "We can't update some of the links in your workbook right now."
Solved by Z. Q. in 15 mins
I am looking for a more detailed explanation about how excel links work. For example if i copy data from one sheet and paste it as a link does it create a one-way link or a 2-way link and does the link break if the source or destination is changed. Also how efficient/inefficient are links? if i have 5000 links will it be a heavy performance loss?
Solved by A. J. in 13 mins