Office for Mac Issues

Fix Excel for Mac Resetting Settings and Losing Recent Files

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 868 views

Question details

Find out why Excel for Mac settings and recent file history disappear after macOS restarts and how to restore normal behavior.

Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user restarts the Mac and then opens Excel to work with previously used settings and files.
Observed behavior
Excel intermittently returns to default settings and loses its recent file history.
Before you start

Quit all Office apps and make copies of the Excel container and any Office group-container folders before moving them. If you use Outlook, export or otherwise back up its local data first: the Office group container can contain Outlook data.

Solution 1Recommended

Reset Excel and Office preference and authentication data

Use this approach when corrupted Excel preferences, Office authentication entries, or shared Office container files may be causing the reset.

Work through the steps in order and test Excel after resetting its container. Resetting shared Office data can sign you out and affect other Office apps, including Outlook.

1
Quit Office apps

In each open Office app, choose the app name in the menu bar and select Quit. Confirm that Excel, Word, Outlook, and other Office apps are closed.

2
Move the Excel container

In Finder, choose Go > Go to Folder and enter ~/Library/Containers/. Locate com.microsoft.Excel, make a copy in a safe location, and move the original to a separate temporary folder. Then open Excel and check whether settings and recent files persist after a Mac restart.

3
Check Office Keychain entries

If the issue continues, quit Office apps again and open Keychain Access from Applications > Utilities. Search for Office and ADAL, and remove only entries you can identify as Microsoft Office authentication data. You may need to sign in to Office again.

4
Reset shared Office containers if needed

In Finder, choose Go > Go to Folder and enter ~/Library/Group Containers/. After backing up any Outlook data and the folders themselves, move the Office-related folders UBF8T346G9.Office and UBF8T346G9.OfficeOsfWebHost, if present, to a temporary location.

5
Restart and test Excel

Choose Apple menu > Restart, open Excel, and sign in to Office when prompted. Change a setting, open a file, and restart the Mac again to see whether the setting and recent file remain.

Reset Excel and Office preference and authentication data
Outlook data may be affected: Moving the shared Office container can make local Outlook data unavailable. Keep the backed-up folder until you have verified your Outlook data and Office apps.
Free Microsoft Office alternative

Work with Excel Files in WPS Spreadsheet for Mac

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheet files. It supports common Microsoft Office formats, making it easier to move your work between apps without claiming to repair Excel itself.

Open and edit spreadsheets in a familiar interface.Compatible with common Microsoft Excel formats, including XLS and XLSX.A free, lightweight option for everyday spreadsheet work.Supports common Word and PowerPoint formats for moving other Office documents.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac lose its recent file list?

Corrupted Excel preferences, Office authentication data, or shared Office container files may contribute to the problem. Try resetting the Excel container first, then check shared data if the issue continues.

Will resetting the Excel container delete my spreadsheets?

Moving the Excel container resets app data and may affect files stored inside that container. Make a copy before moving it, and check the location of any files you need before proceeding.

Why should I back up Outlook data before resetting Office containers?

The shared Office group container can hold local Outlook data. Back up or export that data and copy the container before moving it from ~/Library/Group Containers/.

Where can I find Microsoft Office authentication entries?

Open Applications > Utilities > Keychain Access and search for Office and ADAL. Remove only entries you can identify as Microsoft Office authentication data; Office may ask you to sign in again.

What should I do if Excel still resets after clearing Office data?

Start the Mac in Safe Mode and test Excel, then restart normally. If the behavior differs, review login items and other startup software for possible conflicts.