by

Excel Breaking Links Not Working

Excel Breaking Links Not Working

  1. Excel Breaking Links Not Working
  2. Hyperlinks Not Opening In Excel
  3. Excel Breaking Links Not Working
  4. Breaking Links In Excel Not Working
  • Open the workbook with the broken hyperlink(s). You can usually open the file in Excel by double-clicking its filename. Use this method if you've already checked your hyperlinks for accuracy and the links are still not working. Excel checks your hyperlinks when you save the file—if the hyperlinks are not working at the moment you save (for example, if you save when you'.
  • If I copy the addres to the browsers addressbar, the page opens. If I click on the link in the cell in Excel, the page doesn't work. The link refers to a page I have to login for. But if I am loggede in on another tab, pasting the url on a new tab works fine. But clicking on the URL whether it be from Excel or Word, won't work.

Trying to break excel links but excel can not break links? It may be because you have referred external file in the data source of excel objects or validations.

Breaking link dialog box pops up every time workbook is opened. First Duplicate the file and save it. Now start working on the duplicate file so that your main file is safe. Check the data validation if they contain links to external files. Im working with Excel 2010, I have numerous external files that I link to. When I go to 'Check Links' some of the files show up as source not found. If I click on Open Source, it actually opens the right document. I am on a network, BUT the files that Im linking to are in the SAME directory on the network that have issue. Open the workbook that contains the broken link. On the Data tab, click Edit Links. The Edit Links command is unavailable if your workbook doesn't contain links. In the Source file box, select the broken link that you want to fix. Note: To fix multiple links, hold down.

Excel warning messages become a headache if excel cannot break links when tried. In normal cases, it is easy to break links in excel files by just Alt + A + K or by going to Data tab-> Queries & Connection manually. Then you have to select the wanted link to break and press the “Break Link” button. This option allows you to break visible known normal external links. ButWhat if excel won’t break external links even after trying this method?

Table of Contents

  • How to break excel links?

Why Excel can not break links?

Excel fails to break external links if they are used for Data Validation or defining names in Names Manager.

Error

In normal cases, if external links are placed in excel date cells you can select and see them, so you can delete, break or edit them manually. But if they are used in the following excel features,

WorkingWindows
  • Data Validations
  • Defined Name range in Name Manage
  • Charts

Excel won’t break them using the Edit link option, you have to break them manually. Hence, if links are from the missing files every time you open an excel file following error message will keep appearing.

Excel Breaking Links Not Working

How to break excel links?

To break links you have to look for links used in the formula or data source of excel features. If you found one, verify is it the same which causing the problem, and if “yes” then fix it.

1Break Excel Links used in Data Validation

If external links are used in Data Validation or in Names Manager they are not available to access through applied data cells. It becomes more difficult when you don’t know exactly which cells of rows and columns are used in data validation.

Follow these steps,

Step-1: First identify & select the data range (i.e cells, columns, rows) that have applied data validation referring to external files. If you don’t know then simply select all (Ctrl + A)

Step-2 : Then go to Data tab-> Data Validation (Alt + A + V+V).
If your selection is perfect then it will show you referring file address as shown in the above screenshot. Otherwise, it will not and you have to select a large cells range (i.e select all).

Step-3: Then click on “Clear All”. It will clear all data validations from selected cells and so links.

Note: Clear All will remove all applied data validation from the selected range. You have to again set up validation to the required cells.

2Break Excel Links used in Name ranges

If external links are used in defining names in Names Manager you can delete or edit them by editing names only. You can not break these links from the Edit Links dialog.

Follow these steps,

Step-1: Goto Formula tab->Name Manager (Alt + M + N)

Step-2: Look for a defined name with an external link in the “Refers To” column

Step-3: Edit/Correct or delete defined Name range

Note: Deleting a defined Name will cause an error in cells that contain the same Name as part of the formula.

3Break Excel Links used in Charts

Moving excel charts to external files cause the creation of phantom links (links to external file you haven’t create). You have to look for such link in data source and code of excel charts if there is any.

Follow these steps,

Step-1: Select excel chart then Right click->Slect Data.. source

Step-2: Look for links with the external file name

Step-3: Edit/Correct or delete defined source

If your links are in VBA code, select item and press Alt + F11 to open VBA project manager. here you can check if there is any external link that is causing the problem.

FAQ

Break link in excel not working, what to do ?

If break link in excel is not working then you have to search and break links manually. Look for the links in data validation, name manager, and data source of charts. You can also use paid link break addon.

How do I force break links in Excel?

If excel cannot break links normally using the edit link option you can break it forcefully using the manual search and edit method. Look for phantom links in various excel features data sources. Such as data validation, charts, and name manager.

How do I remove hidden external links in Excel?

Some external links are hidden in the data source of data validation, names, and charts. You can remove hidden external links in excel by looking inside sources of charts, names, and data validations.

How do I remove a ghost link in Excel?

Ghost links also called phantom links, they are hidden in the data source and VBA code of excel object. You can remove ghost links by manually searching and editing. Check and verify data source of excel objects, formatted and validation applied cells.

How do you fix external links in Excel?

You can fix external links in excel by breaking them. If edit links (Alt+A+K) not working, look for external links in the data source of applied data validations, excel charts, and names manager. Also, look in the VBA code if applicable.

Conclusion

Excel cannot break links if they are used in the data sources of excel features and objects. Links may become a ghost or phantom links if you move sheets, objects (such as charts) to another sheet. It can also cause problems when you move, edit, or remove referred excel files. You have to reconfigure and correct reference formulas and data sources to fix such link-related issues.