How to Fix Excel for Mac 'Missing Named Items' Error When a Workbook Won't Open
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.

- 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.
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.
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.
Open Excel for Mac, go to Help > Check for Updates, or open Microsoft AutoUpdate from the Applications folder.
In Microsoft AutoUpdate, click Check for Updates and install all available Microsoft Office updates for Excel.
Choose Apple menu > Restart, then log back in to complete the update.
Open Excel for Mac and try to open the workbook that shows the missing named items error.

Collect Diagnostic Details and Contact Microsoft Support
Use this when the update does not resolve the error and you need to report the file-specific issue to Microsoft.
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. 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. Open WPS Spreadsheets: Launch WPS Office, then click Spreadsheets to open the spreadsheet editor.
- 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.

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.




