Fix Excel for Mac Resetting Settings and Losing Recent Files
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.
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.
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.
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.
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.
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.
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.
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.

Test Excel in macOS Safe Mode
Use Safe Mode if the reset continues after checking Office data, or to see whether startup software contributes to the issue.
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.

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.




