Fix Excel Administrator Closed Recent Workbooks Message
Question details
The user needs to troubleshoot an Excel message indicating that an administrator closed the most recent workbook or disabled the Recent files list.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user opens Excel and wants to view recently opened workbooks, but the Recent list is unavailable or an administrator-related message appears.
- Observed behavior
- Excel displays a message that an administrator closed the most recent workbook, or the Recent files list is missing from File > Open.
Confirm that you are signed in to the correct Microsoft 365 account and that Excel is fully closed before changing settings. If the device is managed by an organization, check whether you have permission to change Office policies.
Check Excel’s Recent files list and local history setting
Use this first when the Recent list is missing but you manage the device or can change Excel preferences.
The message commonly appears when recent-file history is disabled by an Office policy or local Excel setting. A setting controlled by your organization may be unavailable or locked.
Start Excel, select File, choose Open, and look for the Recent section. If it appears, select a workbook from the list to confirm that recent history is available.
In Excel, select File > Options > Advanced. Scroll to the Display section and check Show this number of Recent Workbooks. Enter a value greater than 0, select OK, and restart Excel.
Open File > Account and review the available account or privacy settings. If the Recent Workbooks option is missing, disabled, or locked, the setting is likely controlled by an Office policy.
Ask the Microsoft 365 administrator to restore recent-file history
Use this solution when Excel identifies an administrator action or the relevant settings are locked by your organization.
Use WPS Spreadsheet for a Lightweight Recent-File Workflow
If the Excel message is caused by Microsoft 365 administration, WPS Office provides a separate, lightweight spreadsheet environment for opening, editing, and organizing compatible workbooks. Its familiar interface and support for Microsoft Excel formats make migration straightforward without changing your organization’s Excel policies.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the Start menu or Applications folder.
- 2. Open the workbook: Select Open from the WPS Spreadsheet home screen or choose Menu > Open, then select an .xlsx or .xls file.
- 3. Continue editing and sharing: Edit the workbook in WPS Spreadsheet and use Save or Save As to retain the Microsoft Excel format when sharing the file.

Frequently Asked Questions
Why does Excel say an administrator closed the most recent workbook?
The message usually means that recent-file history has been disabled by an Office privacy setting or an organizational policy. If the setting is locked, only your Microsoft 365 administrator can change it.
Where can I check the Recent Workbooks setting in Excel?
Open Excel and go to File > Options > Advanced. In the Display section, check Show this number of Recent Workbooks and make sure the value is greater than 0.
What should I do if the Recent option is missing under File > Open?
Check File > Options > Advanced and review the Display section. If the setting is unavailable or greyed out, contact your Microsoft 365 administrator because a policy may be controlling it.
Will restarting Excel restore the Recent files list?
Restarting Excel can apply a newly enabled setting, but it will not override an organizational policy. Close all Excel windows, reopen the app, and check File > Open > Recent after the setting has been changed.




