Office for Mac Issues

Remove External Links from Defined Names in Excel for Mac

Adam DavisAdam Davis Nov 20, 2026 869 views

Question details

Find and remove defined names that reference external workbooks when the necessary Name Manager tools are unavailable in Excel for Mac.

Remove External Links from Defined Names 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook on Windows

Open a copy of the affected workbook in Microsoft Excel for Windows.

2
Inspect defined names

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.

3
Edit or delete unwanted names

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.

4
Save and check on the Mac

Select File > Save, then reopen the workbook in Excel for Mac and check the affected formulas and any link prompts.

Remove External References with Name Manager in Excel for Windows
Other external links may remain: External references can also appear in formulas, charts, queries, and other workbook features. Removing defined names may not remove every external link.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats, including XLSX and XLSReview spreadsheet formulas and workbook dataFree and lightweight for everyday office work
microsoft office alternative - wps office

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.