Excel won't let you break external links: what to check

Si Excel doesn't let you break external links If the warning reappears after deleting them, it's worth checking what dependency the file retains. This could be a formula, a defined name, a chart, or a data connection that requires a different review.

Before modifying the workbook, save a copy. Breaking links can replace formulas with their current results, and those results may not be up-to-date. The goal is to remove dependencies you no longer need without losing calculations or functions from the document.

Check which external link keeps appearing in Excel

In current versions of Excel for Windows, open Data > Queries and Connections > Book LinksIdentify the source file that appears in the panel. In previous versions, you might find the command Edit links.

Open the options for the corresponding source and select Breaking tiesThis operation converts the affected formulas to their current values; it is not equivalent to repairing the source file.

If you need to maintain automatic updates and the source has simply changed location, use Change source instead of breaking the dependency.

Note the name of the external file before continuing. This will help you check if the same reference persists or if the workbook contains several different dependencies.

If the button is disabled, check the editing permissions.

A disabled control does not allow you to conclude that the sheet is protected. First, check if you can modify and save the file, if you have editing permissions, and if a warning appears. Protected view.

If the document comes from a trusted source and you need to edit it, use the appropriate option in the warning. Do not globally disable Protected View to resolve a single file.

Next, check the protections from Review:

• Leaf protection: restricts the operations allowed on its cells and elements.
• Book protection: It can prevent changes to its structure, such as moving or deleting sheets.

Remove only the protection that applies and for which you have authorization. If a password is required, request it from the owner. Unprotecting a sheet does not automatically remove other file restrictions.

Locate references in formulas and defined names

Open Look for, expand its options and select Inside: Book y Search in: FormulasSearch for the name of the external file; you can also try with .xl to locate references to common books.

This search is a help, not an exhaustive check of all dependencies.

Check back later Formulas > Name ManagerObserve the field It refers to to identify names that point to another file.

Do not remove a name just because it is external. First, check if any formulas, lists, or charts use it. When you need to preserve its function, you can prepare the data within the workbook itself and modify the name to point to the local range.

The Name Manager does not display all hidden names or names defined using VBA. If the warning persists and you cannot find the source, a technical review of the file copy may be necessary.

Check graphs, objects, and data connections

Links aren't always in cells. Select the charts and review their data series and titles. There may also be references associated with text boxes, shapes, or other objects.

When you select those items, check if the formula bar displays the external file. If you want to keep the chart, change its data source to local data before removing the dependency.

To check the connections, open Data > Queries and ConnectionsA Power Query query or a connection to another data source is managed separately from the links between formulas.

Identify which query feeds each table or report before modifying it. Breaking book links does not guarantee that all data connections will disappear. It is also not advisable to delete queries indiscriminately: you could prevent a report from being updated again.

If the document contains macros and the dependency reappears after opening it or running a procedure, ask them to review that code. You don't need to enable unknown macros to locate a link.

Review the lists and rules without deleting them indiscriminately.

If you have changed a defined name that used drop-down lists, check its functionality from Data > Data ValidationReplace the source where appropriate and verify that users still have the necessary options.

You can also review Home > Conditional Formatting > Manage Rules to check the formulas and ranges used. Excel does not directly support external references to another workbook in these rules, so it's not advisable to assume that any conditional formatting maintains the link.

Avoid deleting all validations or rules as a cleanup method. You might remove important controls without identifying the dependency that's causing the warning.

If you only need the results, create a value copy.

If you need to deliver a static report, you can create a new workbook and copy only the necessary results using Home > Paste > Values.

This method preserves the results of the selected cells but removes their formulas. It does not automatically reconstruct charts, queries, macros, or the logic of the original document.

Copy a whole sheet with Move or copy It does not guarantee that it will remain independent. Formulas and charts need review, and moving sheets can change references or produce unexpected results.

Before submitting the copy, check the totals, dates, errors, and items that need to be retained. Keep the original separately so you can retrieve the calculations.

Save, reopen, and check the result.

After each relevant change, save the copy, close it, and reopen it. Check both the links panel and the report queries and results.

El Document inspector It can detect certain external links, but it doesn't remove them for you. Use it as an additional check, not as a guarantee that the file is free of dependencies.

Hiding the update notification doesn't remove the links either. If the message reappears, it retains the source name and the time it reappears: this information allows you to continue reviewing without blindly deleting items from the workbook.