Office Settings & Configuration

Fix Excel Administrator Closed Recent Workbooks Message

Amos GikundaAmos Gikunda Nov 12, 2026 869 views

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.

Fix Excel Administrator Closed Recent Workbooks Message
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Recent files view

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.

2
Review the Recent Workbooks setting

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.

3
Check privacy and policy controls

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.

Managed device limitation: Do not attempt to bypass an organizational policy. Contact your Microsoft 365 administrator if Excel does not allow you to change the Recent files setting.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the Start menu or Applications folder.
  2. 2. Open the workbook: Select Open from the WPS Spreadsheet home screen or choose Menu > Open, then select an .xlsx or .xls file.
  3. 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.
Open and edit common .xlsx and .xls workbooks with a familiar spreadsheet interface.Use a lightweight alternative when Microsoft Excel settings are restricted or unavailable.Manage spreadsheet files in WPS Office without depending on an organization’s Excel Recent-files policy.Keep Microsoft Excel format compatibility when sharing workbooks with Office users.
microsoft office alternative - wps office

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.