'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for Mac Open Recent Menu Empty or Missing Files
Question details
The user is unable to view recently opened files because the Open Recent menu in Excel for Mac is empty.
- Product
- Excel for Mac
- Device & OS
- macOS Ventura 13.5.2
- Scenario
- Attempting to quickly access previously opened spreadsheets using the Open Recent menu in the Excel application.
- Observed behavior
- The Open Recent menu displays no files and is completely empty, even though similar settings work fine on another Mac computer.
Ensure you have saved your current work and completely closed all Microsoft Office applications using the Command-Q shortcut before making changes to your Mac system settings.
Adjust macOS System Settings for Recent Documents
Because macOS controls the number of recent items displayed across applications, adjusting your Mac's System Settings is the most reliable way to restore the missing Open Recent menu list in Excel.
The 'Open Recent' list in Microsoft Office applications on a Mac is directly governed by macOS system preferences, rather than the internal settings of the Excel application itself. If your Mac's system settings are configured to not track recent files, Excel's recent menu will remain completely blank.
Ensure Excel is completely closed. Press Command-Q on your keyboard to fully quit Microsoft Excel and any other running Office applications.
Click the Apple logo located in the top-left corner of your Mac screen and select System Settings (or System Preferences on older macOS versions).
Navigate to the Control Center (or Desktop & Dock, depending on your macOS version) and scroll down to locate the 'Recent documents, applications, and servers' setting.
Click the drop-down menu next to the recent items option and select a specific number, such as 10 or 20, ensuring it is not set to 'None'.
Launch Microsoft Excel again. Click on the File menu and check the Open Recent list to verify that your recently accessed workbooks are now populating correctly.
Try WPS Office for Mac for Seamless File Management
If you are tired of troubleshooting missing recent files and complex system settings in Microsoft Excel, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative designed to run smoothly on macOS with a reliable built-in file manager.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office installer for Mac, then follow the on-screen instructions to install it.
- 2. Launch the Application: Open WPS Office from your Applications folder or Launchpad to access the unified home dashboard.
- 3. Access Recent Files Reliably: Click on the 'Recent' tab on the left sidebar of the WPS dashboard to instantly view and open your previously accessed files without relying on macOS system preferences.
Frequently Asked Questions
Why did my Excel recent files suddenly disappear on my Mac?
This typically occurs when your macOS system settings for recent items are accidentally changed to 'None', or if a recent macOS system update temporarily resets your personalized system preferences.
Are my missing recent files deleted from my Mac?
No, the Open Recent menu is simply a list of shortcuts to your files. Your actual Excel spreadsheets are still safely stored in their original locations on your hard drive or cloud storage.
Can I manually clear the Open Recent list in Excel for Mac?
To clear the list, you must adjust the macOS System Settings for 'Recent documents, applications, and servers' to 'None' temporarily. There is no direct button inside newer versions of Excel for Mac to clear this list.
