Breaking a link removes the connection to another file, but keeps the values

When you break a link in Excel, you replace the formulas that point to another file with their current values. The numbers stay. The connection goes. This matters because linked files can slow down your spreadsheet, cause errors if the other file moves or gets deleted, or create security warnings when you open the file.

Excel stores links in two places: inside formulas (like =SUM([Budget.xlsx]Sheet1!A1:A10)) and in the workbook's link table. Breaking a link removes both, but only after you decide whether to keep the numbers that were calculated or discard them entirely.

Key Takeaways

  • Breaking a link converts formulas to values, so the numbers stay but the connection to the other file disappears.
  • You can break all links at once through the Data menu, or break individual links by editing formulas one at a time.
  • If you break a link and then realize you need it, you will have to re-create the formula or restore from a backup — there is no undo that restores the link itself.
  • Linked files can cause Excel to ask for permission to update when you open the workbook, which is why many people break links before sharing a file.

Breaking all links at once through the Data menu

Open the spreadsheet that contains the links. Go to the Data tab at the top. In the Connections group (or Links group, depending on your Excel version), click Edit Links. A dialog box appears showing every file your spreadsheet is linked to.

Select the file you want to break the link to. Click Break Link. Excel converts every formula that pointed to that file into a value. The dialog closes. If you had multiple links, repeat this for each one, or select all of them at once and break them together.

After you break a link, save the file. The link is gone. If you open the file again, Excel will not ask to update the link, and the file will open faster.

Breaking individual links by editing formulas

If you only want to break one or two links and you know where they are, you can edit the formulas directly. Find a cell that contains a formula pointing to another file — it will look something like =[Budget.xlsx]Sheet1!A5.

Click the cell. In the formula bar at the top, you will see the full formula. Delete the formula and type the value you want to keep instead. For example, if the formula calculated to 1500, type 1500 and press Enter. The link is broken for that cell only.

This method takes longer if you have many linked formulas, but it gives you control over which ones to keep and which to remove. Use Find & Replace (Ctrl+H on Windows, Cmd+H on Mac) to search for the filename in brackets — that will show you every cell with a link to that file.

What happens to your numbers when you break a link

When you break a link, Excel keeps the last calculated value. If the linked file had the number 500 in it, and your formula was =[Budget.xlsx]Sheet1!A1, breaking the link leaves you with the value 500 in that cell — but now it is just a number, not a formula.

This means if the original file changes, your spreadsheet will not update. The value is frozen at the moment you broke the link. If you need the spreadsheet to stay current with the other file, do not break the link. If you are sharing the file with someone else and do not want them to see or update the other file, breaking the link is the right choice.

If you break a link and then realize you made a mistake, you can undo it when ready with Ctrl+Z (or Cmd+Z on Mac). But if you have already saved and closed the file, you will need to restore from a backup or re-create the formula by hand.

Why Excel asks for permission when you open a linked file

When you open a spreadsheet with links, Excel shows a security warning asking whether you want to update the links. This happens because the file is trying to connect to another file on your computer or network, and Excel wants to make sure you trust that connection.

If you click Enable, Excel updates the values from the linked file. If you click Disable, Excel opens the file but does not refresh the numbers — they stay at whatever they were the last time you opened the file. Breaking the link removes this warning entirely, because there is nothing left to update.

When to break a link and when to keep it

Keep a link if you are the only person using the file and you need the numbers to stay current with another file. Keep it if both files are in a shared folder that everyone on your team can access. Break a link if you are sending the file to someone outside your organization, if the linked file might move or get deleted, or if you want the file to open without security warnings.

Break a link before you archive a file or send it to a client. Break it if the linked file is on someone else's computer and you do not want your spreadsheet to depend on their file being in the same place. Keep it if the link is part of your workflow — for example, if you update a master budget file every month and several other spreadsheets pull numbers from it.

Checking whether your file still has links after you break them

After you break links, open the Data menu again and click Edit Links. If the dialog is empty or says "No links," you have successfully broken all of them. If files still appear in the list, you have more links to break.

You can also search for link syntax to make sure no formulas are hiding. Press Ctrl+H (or Cmd+H on Mac) to open Find & Replace. In the Find field, type [ (an opening bracket). Click Find All. If the search returns results, you still have linked formulas. If it returns nothing, all your links are broken.

Frequently Asked Questions

Can I break a link to a file that no longer exists?

Yes. Go to Data > Edit Links, select the file, and click Break Link. Excel will break the link and keep the last known values. You do not need the file to be present on your computer to break the link to it.

What if I break a link by mistake?

If you have not saved the file, press Ctrl+Z (or Cmd+Z on Mac) to undo. If you have already saved, you will need to restore from a backup or manually re-create the formula. There is no way to recover a broken link after you save the file.

Does breaking a link change the file size?

Slightly. Formulas that point to other files are larger than plain values, so breaking links can make your file a little smaller. The difference is usually not noticeable unless you have hundreds of linked formulas.

Can I break a link to just one sheet in a workbook?

No. When you break a link, you break the connection to the entire file. If you only want to remove some of the formulas, edit them individually instead of using the Break Link button.

Will breaking a link affect formulas that reference other sheets in the same file?

No. Breaking a link only affects formulas that point to other files. Formulas that reference sheets within the same workbook (like =Sheet2!A1) are not links and are not affected.