Remove External Links from Defined Names in Excel for Mac
Question details
Find and remove defined names that reference external workbooks when the necessary Name Manager tools are unavailable in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A workbook contains defined names that refer to external files, but the user cannot easily inspect or manage them on a Mac.
- Observed behavior
- Excel for Mac may not provide the same Name Manager capabilities as Excel for Windows, making external references in defined names difficult to locate.
Check whether the Formulas tab in your version of Excel for Mac provides the name-management tools you need, and identify any external workbooks the file is meant to use. If you plan to delete names or break links, save a separate copy so you can compare formulas afterward.
Remove External References with Name Manager in Excel for Windows
Use Excel for Windows to inspect defined names when your Mac version does not offer the necessary tools.
Open a copy of the affected workbook in Microsoft Excel for Windows.
Select Formulas > Name Manager. Review the Refers To column for references to external workbook files, such as paths containing a workbook name in square brackets.
Select each unwanted name and choose Edit to change its reference or Delete to remove it. Check whether formulas depend on the name before deleting it, because those formulas may return errors.
Select File > Save, then reopen the workbook in Excel for Mac and check the affected formulas and any link prompts.

Break Workbook Links in Excel for Mac
Use this option if you want to disconnect listed workbook links and no longer need their linked formula results to update.
Work with Excel Files Using WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with them when moving between office suites.

Frequently Asked Questions
How can I find defined names that link to another workbook?
In Excel for Windows, open Formulas > Name Manager and inspect the Refers To column for external file paths or workbook names in square brackets.
Will deleting a defined name affect my formulas?
It can. Formulas that use a deleted name may return errors. In Formulas > Name Manager, inspect the name and its reference before deleting it.
What happens when I break a workbook link?
Excel can replace formulas linked to that source with their current values, so they will no longer update from the source workbook. Review the links under Data > Workbook Links or Edit Links before breaking them.
Why does Excel still show an external link after I remove a defined name?
The reference may be elsewhere, such as in a formula, chart, query, or another defined name. Review the workbook link settings on the Data tab and inspect other workbook features.




