To stop Excel from updating external workbook links, open File > Options > Trust Center > Trust Center Settings > External Content and choose Disable automatic update of Workbook Links. To remove links entirely from a workbook, use Data > Workbook Links and break the links instead. These actions are different: blocking updates preserves link formulas, while breaking links replaces linked formulas with their current values.
What You’ll Need
- Excel for Microsoft 365 on Windows, with the workbook open.
- Permission to change Excel’s Trust Center settings if you want to block updates for all workbooks. A workplace administrator may manage or lock these settings.
- A separate copy of the workbook before breaking links or removing connections. Breaking links can permanently remove formulas, and it cannot be reversed with Undo after saving and closing.
Step-by-Step
- Decide what you mean by “disable.” If you want to keep formulas that refer to another workbook but prevent Excel from refreshing them automatically, block automatic updates. If you want the file to work without the source workbook and no longer contain those formula links, break the links. If you mean links that people click to open websites or files, those are hyperlinks and need to be removed separately. A data connection, such as a Power Query connection, is another distinct type of external reference.
- Save a working copy. Use File > Save As and give the copy a different name. This is especially important before breaking links: Excel generally replaces formulas linked to other workbooks with their most recently calculated values. Those formulas will no longer recalculate from the source, and the change may affect charts, totals, or later analysis. Keep the original file until you have checked the copy.
- Find workbook links in the file. In Excel for Microsoft 365 on Windows, open the Data tab and look for Workbook Links. Selecting it opens a panel listing linked workbooks when Excel can identify them. Depending on the Excel build and workbook, the older command may appear as Data > Edit Links; some versions also provide File > Info > Edit Links to Files. If no command or link list appears, do not assume the workbook has no external references: formulas, names, charts, queries, or other features can contain references that need separate inspection.
- Block automatic updates for all workbook links (Windows). To change Excel’s general behavior, select File > Options > Trust Center > Trust Center Settings > External Content. Under Security settings for Workbook Links, select Disable automatic update of Workbook Links, then choose OK to close the dialogs. This prevents automatic updating; it does not erase the links. Excel may still show a notice or offer a manual update, depending on the workbook and your settings. The Trust Center also has separate controls for data connections, so changing the workbook-link option does not necessarily block queries or other connections.
- Set a prompt for one workbook in older link controls. If your version has the classic Edit Links dialog, select Startup Prompt. Choose the option that does not display the alert and does not update automatic links if you want that workbook to open without refreshing them. Choose the prompt option if you want to decide when opening. The exact choices depend on the Excel version; this setting controls opening behavior for that workbook, not whether its link formulas exist. If you cannot find Startup Prompt in your build, use the Trust Center setting in the previous step or leave the links unchanged and decline updates when prompted.
- Break the workbook links if you want to remove them. In Data > Workbook Links, select a listed source and use Break links or the equivalent command shown in the panel. Confirm only after checking that you have a backup. In the classic Edit Links dialog, select the source workbook and choose Break Link. Excel converts linked formulas to their current displayed or calculated values; it does not simply switch off the link while preserving a live formula. Repeat for each source if there is more than one, then save and reopen the copy to check the result.
- Review connections separately. Select Data > Queries & Connections to inspect queries and workbook connections. If a connection is no longer needed, review what uses it before removing it. For a query, deleting or disabling its load or refresh behavior may affect a table or report; for a connection, use its available properties or remove command only when you are sure the workbook does not depend on it. To restrict connections broadly on Windows, return to File > Options > Trust Center > Trust Center Settings > External Content and review Security settings for Data Connections. This setting is separate from workbook-link security.
- Check clickable hyperlinks if those are your concern. External workbook links in formulas are not the same as hyperlinks in cells, shapes, or images. To remove a cell hyperlink, right-click the cell and choose Remove Hyperlink; in some Excel builds, select the cell and use Home > Clear > Remove Hyperlinks. Removing a hyperlink usually leaves the displayed text in place. Check shapes and other objects too if they may contain clickable links. Save the file, close it, and reopen it to confirm the behavior you wanted.
Common Mistakes
- Assuming “don’t update” means “remove.” Blocking an update leaves the source reference in the workbook. The link may still appear in the link panel, and another user could update it in an environment with different settings.
- Breaking links before saving a copy. Once a formula is replaced with a value, the original calculation cannot be restored from that cell unless you recover an earlier file or recreate the formula.
- Confusing hyperlinks with formula links. Removing a clickable web address from a cell does not remove a formula that refers to another Excel file. Identify which type you need to change before taking action.
- Forgetting connections and queries. A workbook can have a live data connection even when the Workbook Links list is empty. Check Data > Queries & Connections as well.
- Expecting a Trust Center setting to travel with the workbook. The setting that disables automatic updates is an Excel application setting on your computer. Other people opening the file may have different settings.
Tips
Before breaking links, check a few important cells and note whether they contain formulas or values. Afterward, test totals, charts, and reports that depend on those cells. If you need to retain a record of the source, keep a dated copy of the original workbook or document the source file and the date of the values you preserved.
For a workbook you share, explain whether its figures are frozen values or are expected to refresh from another file. A recipient who sees an update prompt may not know whether updating is safe. If you only want to prevent unexpected changes on your own computer, use the Trust Center setting rather than breaking links in a shared file.
On Mac, Excel’s Windows Trust Center path and options are not available in the same form. Look for Data > Workbook Links in current versions to review or manage links, and check your version’s settings before relying on automatic-update controls. Excel for the web has more limited link-management options; use the desktop app for breaking links or changing Windows Trust Center settings.
Troubleshooting
The workbook still asks to update links. Confirm that you changed the setting under Workbook Links, not only the separate Data Connections section. If the prompt is for one file, inspect its classic Edit Links > Startup Prompt options if available. Close and reopen the workbook to test. An organization’s policy may override your choice.
No links appear, but Excel still shows an update message. Check Data > Queries & Connections for refreshable connections and queries. Also inspect formulas, defined names in Formulas > Name Manager, charts, and objects. External references can be embedded in workbook features that are not listed as ordinary formula links. If a source file was moved or renamed, the reference may be broken rather than absent.
Break links is unavailable or does not remove every reference. The selected item may be a connection rather than a workbook formula link, or Excel may not support breaking that particular reference from the panel. Check other listed sources and inspect names, charts, conditional formatting, and data validation for references. Make changes to the copy, and avoid deleting an entire query or connection until you know which tables or reports rely on it.
Values changed after breaking a link. Excel uses the value available when it breaks the link, which may be stale if the source was not updated first. If you need the latest source figures, update the source and confirm the workbook’s calculations before breaking the link. If you already saved over the only copy, look for a backup or version history; Excel’s Undo command cannot reliably restore a broken link after the operation is completed or the file is closed.
Frequently Asked Questions
Can I disable external links without deleting their formulas?
Yes. On Windows, use File > Options > Trust Center > Trust Center Settings > External Content and disable automatic updates for Workbook Links. The formulas remain, but their values will not automatically refresh from the source.
Will breaking a link keep the current numbers?
Usually, yes: Excel replaces linked formulas with their current calculated values. Verify those values before breaking links, especially if the source workbook is unavailable or has not been updated recently.
Does removing an external link also remove a hyperlink?
No. A formula reference to another workbook and a clickable hyperlink are different. Remove hyperlinks separately from cells, shapes, or other objects.
Can I stop links from updating in just one workbook?
In versions with the classic Edit Links dialog, use Startup Prompt to control the opening prompt and whether automatic links update. If that control is not available, the Trust Center setting applies at the Excel application level, so it can affect other workbooks too.
Why is Excel still refreshing data after I disable workbook links?
It may be refreshing a query or data connection, which has a separate setting. Review Data > Queries & Connections and the Trust Center’s data-connection options. A workbook-link setting alone does not disable every kind of external content.
Can I do this in Excel for the web?
Some link details may be visible, but the web app does not provide all desktop link-management and security controls. Open the workbook in desktop Excel to break workbook links or change Windows Trust Center settings.
Related
- How to Delete Duplicate Data in Excel
- How to Delete Duplicate Entries in Excel
- How to Delete Certain Data in Excel Without Losing More
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change the Color Scheme in Excel and Save ItIn Excel for Microsoft 365 on Windows, go to Page Layout > Themes > Colors and choose a…
- How to Align Names in Excel: Cells and ListsTo align names in Excel, select the name cells and choose Home > Alignment > Align Left, Center,…
- COUNTA in Excel: What It Counts and How to Use ItIn Excel, COUNTA counts cells that are not empty, including cells with text, numbers, dates, logical values, errors,…
- Excel Flash Fill Shortcut: Ctrl+E and How It WorksIn Excel for Microsoft 365 on Windows, the Flash Fill keyboard shortcut is Ctrl+E. Enter an example of…
- Google Sheets COUNTIF With Multiple Criteria ExplainedGoogle Sheets’ COUNTIF function accepts one condition; to count cells that meet multiple conditions at the same time,…
- Entire Excel Sheet Not Responding? Fixes That WorkIf an entire Excel sheet or workbook is not responding, first wait briefly if Excel is calculating or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.