logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Find and Remove External References (Data Links) in Formulas...

ASAP Utilities  › File & System  ›  7. Find and Remove External References (Data Links) in Formulas...

This tool helps you find and remove external references (also called data links or workbook links) in your workbook's formulas. External references are formulas that refer to other workbooks. For example:
='C:\Sales\[Q1.xlsx]Sheet1'!A1 These links can slow down your workbook, create dependencies on other files, or cause broken links when the source file is moved or deleted.

With this tool, you can:

  • See a list of all found external references (data links) used in formulas
  • Choose which links to remove
          ·  Formulas that use the link will be replaced with their current calculated value
          ·  Formulas that use a name (defined name) referring to that link will also be replaced with their current value
          ·  Any name (defined name) that referred to the removed link will automatically be deleted  
  • Create a report of all found links for documentation or review

    It's useful when:

  • You want to remove unwanted or broken links to other workbooks
  • You no longer need live links to external data
  • You want to clean up your file before sharing
  • You want to improve performance by removing unnecessary links

    Important notes:

  • This tool only finds links used in formulas (including names with links used in formulas).  
  • Links in other locations, such as charts, shapes, defined names not used in formulas, or conditional formatting, are not detected, due to limitations in Excel's VBA object model.

    Comparison with Excel's built-in Break Links feature:

    This tool works somewhat similarly to Excel's:  
    Data > Queries and Connections > Workbook Links > Break Links (Excel 365)
    However, Excel's Break Links feature can leave behind names (defined names) that still refer to =#REF! after breaking the links.
    This tool automatically removes any defined names that referred to a removed link, helping to avoid leftover broken names and keeping your workbook cleaner.

    Screenshots

    File & System  ›  7 Find and Remove External References (Data Links) in Formulas...

    Starting this tool


    File & System  ›  7 Find and Remove External References (Data Links) in Formulas...
    Additional keywords for this tool:
    external links, external references, workbook links, data links, break links, remove links, delete links, remove external formulas, break external references, remove workbook links, remove data links, find external links, clean workbook links, fix broken links, unlink workbook, break data connections, remove links from formulas, replace links with values, external reference cleanup, Excel links manager



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.