To remove links from an Excel workbook, first identify whether each item is a cell hyperlink, a HYPERLINK formula, a workbook connection, or an object link, because each type requires a different removal method.

Most users only need to remove a hyperlink from a cell while preserving the text shown inside it. A broader cleanup may also involve formulas, workbook connections, shapes, or images, and those items should not be treated as equivalent.

Work on a copy of the workbook before changing links. This preserves the original if a cleanup removes more than expected or exposes formulas and cached values that still need attention.

how to remove excel links
How to Remove Excel Links: Cell and Workbook Links

Start by determining what the link represents. The visible address can look identical across several Excel features, but the stored object and removal control are different.

Link type How to recognize it Correct removal approach
Attached cell hyperlink The cell contains a clickable target stored as hyperlink metadata. Use Remove Hyperlink to retain the displayed text, or clear the cell contents to remove both.
HYPERLINK formula The formula bar contains a formula beginning with =HYPERLINK. Replace the formula with its displayed value using Paste as Values.
URL-like plain text The cell displays an address but has no actual hyperlink attachment. Edit or delete the text; there is no cell hyperlink attachment to remove.
Workbook or data connection It appears in Excel's Workbook Links area rather than as a cell hyperlink. Select the connection and use Break Link.
Shape or image link The clickable target belongs to an inserted object rather than a worksheet cell. Remove the hyperlink attachment with the object's link controls, or delete the object when appropriate.

These categories matter during an audit. A URL displayed in a cell is not necessarily an attached hyperlink, while a formula can produce a URL-looking result without storing one as ordinary hyperlink metadata.

For attached cell hyperlinks, use Excel's own hyperlink controls instead of deleting the cell immediately. This preserves visible information when the text remains useful.

  1. Make a working copy. Open the .xlsx file and save a separate copy for the cleanup. Keep the untouched original available for comparison.
  2. Locate the linked cell. Right-click a candidate cell and inspect its context menu and formula bar. If the address is stored as an actual hyperlink, Excel should offer a hyperlink-related command. Visible URL text alone does not prove that an attachment exists.
  3. Remove the hyperlink but keep the text. Right-click the hyperlink and select Remove Hyperlink. The cell can remain in place with its displayed text, but it should no longer carry the same attached target.
  4. Remove the hyperlink and its text. Select the cell, right-click it, and choose Clear Contents if the complete cell value should disappear. Use the specific contents command rather than clearing the worksheet around it.
  5. Replace a HYPERLINK formula with its value. Select the formula cell, copy it, and use Paste Special or the paste menu's Values option. This leaves the displayed result while removing the formula that generates it.
  6. Handle linked shapes or images separately. A hyperlink attached to a shape is not the same as a cell hyperlink. If the object is no longer needed, select it and delete it; otherwise remove its hyperlink attachment through the object's link-editing controls.
  7. Save and check the result. Save the cleaned copy, reopen it, and inspect the affected cells. A second link inventory can confirm that the attached cell targets are gone, but it will not evaluate remaining formulas.

A workbook link transfers or refreshes data between files; it is not removed with the cell-level Remove Hyperlink command. In Excel, open the Data tab, find Queries and Connections, and open the Workbook Links area.

  1. Review the connection list. Identify the external workbook or data source connected to the file. Check the affected worksheet cells or outputs so you know which data needs review after disconnection.
  2. Select the intended link. Choose only the connection you want to break. Excel can show several sources, and removing the wrong one may leave another path for future updates.
  3. Choose Break Link. This severs the selected workbook connection rather than removing hyperlink text from a cell.
  4. Inspect retained outputs. Values already brought into the workbook may still need cleanup or confirmation, depending on how the workbook uses them. Check formulas, imported ranges, and refresh behavior separately.
  5. Save and reopen without refreshing. Confirm that the unwanted connection no longer appears in the Workbook Links area and that the workbook still opens as expected.

Cell hyperlinks, formulas, and workbook connections should be reviewed as separate cleanup queues. Breaking one type does not prove that the other types have been removed.

For a workbook containing many cells, use the Excel Hyperlink Extractor to create a read-only inventory of stored external cell hyperlinks. The workbook stays in the current browser tab, is not uploaded to Lizely, and is never modified.

  1. Choose one local workbook. Select a non-empty .xlsx file no larger than 20 MB. The file must meet the extractor's package limits before worksheet traversal begins.
  2. Select Extract safe links. The extractor reads accepted hyperlink targets already stored in worksheet cells and presents them as inert plain text.
  3. Review each location and target. Check the worksheet name and cell address beside each normalized URL. Download the .txt report when a local copy is needed for review, handoff, or comparison.

The extractor is an inventory aid, not a cleanup button. It never follows a link, requests a target page, calculates a formula, refreshes a connection, runs a macro or script, or inspects an image. The report is rendered as plain textarea text and downloaded as a .txt file rather than a clickable rich-content preview.

Guardrail Supported behavior
Input package One non-empty .xlsx up to 20 MB, using a classic single-disk OOXML ZIP directory with no more than 2,000 entries and no more than 50 MB of declared expanded data.
Workbook and report bounds A sheet may contain at most 100,000 addressed cells, and the complete report is capped at 1,000 safe links.
Accepted targets Only normalized http, https, and mailto targets are retained.
Rejected targets Relative paths, internal anchors, file and data URLs, JavaScript URLs, malformed values, control-character payloads, and overlong targets are rejected.
Stop conditions Damaged, encrypted, Zip64, legacy .xls, macro-enabled, multi-disk, and oversized packages stop with a visible error instead of producing an apparently complete report.
Excluded content The extractor does not search visible URL text, evaluate formulas, inspect images, run macros, or inventory hidden data connections and embedded web content.

Accepted URLs are normalized through the browser URL parser before deduplication. The first occurrence of each normalized target is preserved, while later occurrences are identified as duplicates. A retained address is not guaranteed to be reachable, trusted, live, owned by a particular person, or safe to open.

Verify the cleanup and review what remains

After saving the edited workbook, repeat the inventory workflow on the cleaned copy and compare the worksheet and cell locations with the original report. This is especially useful when several cells point to the same destination and you need to confirm each location.

  • Check for formulas separately. A remaining =HYPERLINK(...) formula will not be discovered through formula evaluation, even if it displays a complete web address.
  • Do not confuse text with metadata. A cell that merely shows https://example.com may have no hyperlink attachment and may therefore be absent from the report.
  • Review mailto targets too. Email hyperlinks are included alongside web addresses, so they may need removal or separate handling.
  • Check workbook links again. Data connections sit outside the cell-link report and must be reviewed through Excel's Workbook Links area.
  • Inspect linked objects. Shape and image links are outside the cell-link inventory, so object removal needs its own verification.

Keep the source workbook and use the extracted report as a structured checklist. Open a retained target only after deciding separately that it is appropriate for a trusted context; removing the attachment and judging the destination are two different tasks.

If you're weighing options, Excel Keyboard Shortcuts Alternative: Windows, Mac, Web covers this in detail.

If you're weighing options, How to Put Excel Into CSV File: A Practical Guide covers this in detail.