logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Wednesday November 5th, 2025

Tip of the Day | Wednesday November 5th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Find #REF! Formula Errors (Broken References)

This tool quickly finds all cells on your active worksheet that contain #REF! formula errors.
It then selects these cells so you can easily locate and fix the broken references.
It scans the current sheet and selects all cells where formulas refer to missing or deleted cells, ranges, or sheets, resulting in a #REF! error.
This is useful when you want to:
  • Quickly locate and fix broken formulas
  • Clean up workbooks before sharing or archiving
  • Repair errors caused by deleted sheets, ranges, or renamed cells
  • Save time compared to manually using Find & Replace to search for #REF!
    Note:
    Excel displays #REF! when a formula tries to refer to something that no longer exists. This tool automatically finds and selects those problem cells, saving you time compared to searching manually.

    Starting this tool


    Info & List  ›  Find #REF! Formula Errors (Broken References)

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • 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.