Fix the #ADR! Error in Excel When a Workbook Works on Another Computer
Question details
The user needs to identify and fix an Excel #ADR! error that appears on one computer even though the same workbook displays correctly on another computer.
- Product
- Microsoft Excel workbook
- Device & OS
- not provided
- Scenario
- A workbook is opened on a second computer and cells that should show text display the #ADR! error.
- Observed behavior
- The issue remains after reinstalling Microsoft Office and Windows, while the file continues to work correctly on another computer.
Open the workbook on both computers and compare the affected cell formulas, Excel versions, and calculation settings. If the workbook contains external links, make sure the linked files and network locations are available on the affected computer.
Inspect and repair invalid references in the affected Excel formulas
Use this method first when #ADR! appears in specific cells, as it commonly indicates a localized invalid or broken cell reference.
A #ADR! error can represent an invalid reference in a localized Excel installation. It may occur when a referenced cell, worksheet, named range, or linked workbook is missing, renamed, unavailable, or unsupported in the current Excel environment.
Select a cell showing #ADR!, then review its formula in the Formula Bar. Press F2 to identify any reference such as a missing sheet name, a deleted range, or an external workbook path.
Look for reference fragments such as #REF! or a sheet name that no longer exists. Restore the missing worksheet or edit the formula to point to the correct sheet and cell range.
In Excel, go to Formulas > Name Manager. Check whether any names used by the affected formula refer to #REF! or to a sheet, range, or workbook that is unavailable.
Go to Data > Edit Links, if available, and review linked sources. Select a broken source and use Change Source or Open Source, or update the formula to remove an obsolete external reference.
Check Excel compatibility, regional settings, and Safe Mode behavior
Use this method when the formula is valid on another computer but fails only in one Excel installation.
Check Broken Workbook References in WPS Spreadsheets
WPS Spreadsheets lets you open the workbook, inspect formulas, review named ranges, and correct invalid worksheet or external-file references in a familiar spreadsheet interface.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the affected XLSX or XLS workbook.
- 2. Inspect the error formula: Select the cell with the error and review the complete formula in the formula input bar.
- 3. Correct missing sheet or range references: Edit the formula directly to replace a deleted sheet name, invalid cell range, or unavailable external workbook reference.
- 4. Review defined names: Open the Formulas tab and use Name Manager to find names that refer to invalid ranges, then update or remove them.
- 5. Save a repaired copy: Select Menu > Save As and save the corrected workbook as an Excel XLSX file for testing on both computers.
Frequently Asked Questions
What does #ADR! mean in Excel?
#ADR! is commonly a localized indication of an invalid or broken reference. Select the error cell and inspect the Formula Bar for a missing worksheet, deleted range, broken named range, or unavailable external workbook.
Why does the same Excel workbook work on one computer but not another?
The computers may use different Excel versions, updates, add-ins, regional settings, available linked files, or named-range definitions. Compare File > Account > About Excel, Data > Edit Links, and Formulas > Name Manager on both computers.
How can I find broken references in an Excel workbook?
Check affected formulas for invalid references, then go to Formulas > Name Manager to locate names referring to #REF!. Also use Data > Edit Links to review external workbook sources.
Can regional settings cause formula errors in Excel?
Yes. Different regional formats can use different list separators, such as commas or semicolons, and can interpret dates and numbers differently. Compare Windows regional settings and verify the formula syntax used on the affected computer.
How do I test whether an Excel add-in is causing the error?
Press Windows+R, enter excel /safe, and open the workbook in Safe Mode. If the workbook works there, go to File > Options > Add-ins, manage the relevant add-in type, and disable add-ins one at a time.
