Office for Mac Issues

How to Fix Excel for Mac 'Missing Named Items' Error When a Workbook Won't Open

Huma Ashraf ChHuma Ashraf Ch Nov 13, 2026 869 views

Question details

The user needs to troubleshoot an Excel for Mac error stating that the workbook is configured to show named items that are not present, and the file will not open.

How to Fix Excel for Mac 'Missing Named Items' Error When a Workbook Won't Open
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A user tries to open a specific Excel workbook on a Mac and sees a missing named items message instead of the file opening.
Observed behavior
Excel for Mac reports that the workbook is configured to show named items that are not present, and the affected workbook does not open.
Before you start

Note your Excel for Mac version and whether the problem affects only one workbook or all workbooks. If possible, test the same file in Excel for the web to see whether the error follows the file.

Solution 1Recommended

Update Microsoft Excel for Mac with Microsoft AutoUpdate

Use this solution first, because an outdated Office for Mac build can cause workbook errors such as the missing named items message.

Microsoft delivers Excel for Mac fixes through Microsoft AutoUpdate. Installing the latest Office build resolves many workbook-specific errors caused by outdated software.

1
Open Microsoft AutoUpdate

Open Excel for Mac, go to Help > Check for Updates, or open Microsoft AutoUpdate from the Applications folder.

2
Check for and install updates

In Microsoft AutoUpdate, click Check for Updates and install all available Microsoft Office updates for Excel.

3
Restart your Mac

Choose Apple menu > Restart, then log back in to complete the update.

4
Test the affected workbook

Open Excel for Mac and try to open the workbook that shows the missing named items error.

Update Microsoft Excel for Mac with Microsoft AutoUpdate
Update may not fix a corrupted workbook: If the same workbook still fails after updating, the file may contain invalid hidden-name settings.
Free Microsoft Office alternative

Use WPS Office Spreadsheets as a Free Excel for Mac Alternative

WPS Office is a free, lightweight Office suite that opens and edits Excel .xlsx workbooks with a familiar ribbon interface. If Microsoft Excel for Mac refuses to open a workbook because of a missing named items error, WPS Spreadsheets can be a practical way to access the file and continue working without a Microsoft 365 subscription.

  1. 1. Download and install WPS Office for Mac: Go to the WPS Office website, download the Mac version, and drag WPS Office to the Applications folder.
  2. 2. Open WPS Spreadsheets: Launch WPS Office, then click Spreadsheets to open the spreadsheet editor.
  3. 3. Open the affected workbook: Go to Menu > Open, select the .xlsx file that triggers the Excel for Mac missing named items error, and check whether the data is accessible.
Opens and edits .xlsx workbooks without requiring Microsoft Excel for MacFree and lightweight Office suite for macOSFamiliar spreadsheet interface for easy migration from ExcelFull compatibility with Microsoft Excel file formatsCan open affected workbooks so you can access and recover data
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac say the workbook is configured to show named items that are not present?

This usually means the workbook contains hidden names or named-item settings that Excel for Mac cannot resolve. It can be caused by an outdated Excel build or by corrupted hidden-name data in the specific file.

Will updating Office for Mac fix the missing named items error?

It may. Open Microsoft AutoUpdate from Excel > Help > Check for Updates, install the latest Office updates, restart the Mac, and test the workbook. If the error persists, the file likely has invalid hidden-name settings.

Can I open an Excel workbook with missing named items without Excel for Mac?

Yes. WPS Office Spreadsheets is a free alternative that supports .xlsx files, so you can try opening the workbook there to access and edit the data.

What details should I provide to Microsoft Support for this error?

Provide your Excel for Mac version from Excel > About Microsoft Excel, whether other workbooks are affected, whether the file opens in Excel for the web, and a screenshot of the error message.