Forum Discussion

ramoroso105's avatar
ramoroso105
Copper Contributor
Feb 14, 2023

break links excel

Dear all, 

 

I need your help, I tried to break a link in my excel file but it still there. 

How can i remove definitely the link ? 

 

Regards,

excel

3 Replies

Sort By
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Feb 14, 2023
    If the links won't break, it's likely they're present not in formulas but potentially Named items, Data Validation sources, or even through macro buttons being assigned to macros in external workbooks.
  • ecovonrein's avatar
    ecovonrein
    Iron Contributor
    Feb 14, 2023
    Break Links is a PITA. It is buggy as hell. BUT assuming that your sheet has not fallen victim to its many bugs, the biggest issue are Named Ranges. You must delete those yourself. (It won't do it for you EVEN THOUGH it will replace all references to those names with values. Go figure... 😞 ) Be mindful of this: https://feedbackportal.microsoft.com/feedback/idea/f70420a3-4cac-ed11-a81b-000d3a0450e3

Resources