PDF download Download Article PDF download Download Article

If you've linked data from other worksheets in the same project or other spreadsheets in different file, but have since changed that information, this wikiHow will teach you how to break those links in Excel using a desktop computer. Which is useful if you've added links that you no longer want to keep active.

  1. You can either open your project within Excel by going to File > Open or you can right-click the Excel file in your file browser.
    • This method works for Excel for Microsoft 365 and Excel 2019-2007 (Mac and Windows).
  2. You'll see this above the document editing space with Home , Formulas , and View .
    Advertisement
  3. You'll find this in the "Queries & Connections" grouping.
    • If you don't see this button, the Excel sheet you're working on does not have any active links.
  4. You'll see a list of links that are active in your spreadsheet, single-clicking one will highlight it.
    • If you want to select more than one link from the list, hold the CTRL (Windows) or CMD (Mac) key.
    • If you want to select all the links, press CTRL + A (Windows) or CMD + A (Mac).
  5. You'll need to confirm that you want to break the link to continue. [1]
  6. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Article Summary X

      1. Open your document in Excel.
      2. Click the Data tab.
      3. Click Edit Links .
      4. Click the link you want to break.
      5. Click Break Link .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 26,651 times.

      Is this article up to date?

      Advertisement