Your customized Quick Access Toolbar in Excel suddenly reverts to its default state. This erases your frequently used commands and disrupts your workflow. The problem is often caused by a corrupted settings file or a conflict with another Office application. This article explains how to restore your toolbar and prevent it from resetting again.
Key Takeaways: Restoring the Quick Access Toolbar
- File > Options > Quick Access Toolbar > Import/Export: Backs up your toolbar configuration to a file you can restore later.
- Closing all Office apps and deleting the Excel.qat file: Forces Excel to create a new, clean settings file on next launch.
- Running Office Quick Repair: Fixes corrupted program files that can cause settings to be lost.
Why the Quick Access Toolbar Loses Its Customization
The Quick Access Toolbar settings are stored in a small configuration file on your computer. When this file becomes corrupted or cannot be written to, Excel loads the default toolbar instead. Corruption can happen during an Office update, a system crash, or if Excel closes unexpectedly. Another common cause is having multiple Office applications open at the same time, like Word and Excel, which can create a conflict when both try to write user settings.
File permission issues can also prevent Excel from saving changes. If your user profile lacks write permissions for the folder where the settings file is stored, any customization will be lost when you restart the app. Antivirus software sometimes mistakenly quarantines or locks these configuration files, interpreting them as suspicious.
Steps to Restore and Secure Your Quick Access Toolbar
Follow these methods in order. Start with the backup and restore option if you have a recent backup file. If not, proceed to reset the toolbar file.
Method 1: Restore from a Backup File
- Open Excel Options
Click File > Options to open the Excel Options dialog box. - Navigate to Quick Access Toolbar
In the left pane of the Excel Options window, select Quick Access Toolbar. - Import Your Backup
At the bottom right of the dialog, click the Import/Export button. Choose Import customization file from the menu. Navigate to your backup file with the .exportedUI extension and select it. Click Open to apply the settings.
Method 2: Reset the Toolbar by Deleting the Settings File
- Close All Office Applications
Exit Excel, Word, PowerPoint, and Outlook completely. Check the system tray to ensure no Office background processes are running. - Open the Run Dialog
Press the Windows key + R on your keyboard to open the Run command box. - Open the Roaming Folder
Type %appdata%\Microsoft\Excel and press Enter. This opens File Explorer directly to Excel’s settings folder. - Delete the QAT File
Look for a file named Excel.qat. Select it and press Delete on your keyboard. If you see multiple files with similar names, delete all files ending in .qat. - Restart Excel
Launch Excel again. It will generate a new default Excel.qat file. Rebuild your Quick Access Toolbar manually.
Method 3: Run an Office Repair
- Open Windows Settings
Click the Start menu and select the Settings gear icon, or press Windows key + I. - Go to Apps
Click on Apps, then select Apps & features from the left sidebar. - Locate Microsoft Office
In the apps list, find Microsoft 365 or your version of Microsoft Office. Click on it, then select Modify. - Choose Quick Repair
In the window that appears, select Quick Repair and then click Repair. Follow the on-screen instructions and restart your computer when prompted.
If Your Toolbar Still Resets After These Steps
Excel Settings Reset Every Time I Close the App
This indicates the new Excel.qat file cannot be saved. Check folder permissions for the Roaming\Microsoft\Excel directory. Right-click the folder, select Properties, and go to the Security tab. Ensure your user account has Full Control permissions. Also, temporarily disable your antivirus software to test if it is blocking the file.
Only Some Commands Disappear from the Toolbar
Commands that reference macros, add-ins, or custom functions may vanish if the source file is moved, renamed, or disabled. Go to File > Options > Add-ins. At the bottom, ensure the relevant add-in is listed and its status is Active. If you added a macro button, ensure the macro workbook is still open and trusted.
Toolbar Resets When Switching Between Office Versions
Using different versions of Excel, like one from a Microsoft 365 subscription and an older standalone version, can cause conflicts. Each version maintains its own settings file. Customize the toolbar separately for each installed version of Excel you use regularly.
Quick Access Toolbar Reset Solutions Compared
| Item | Import from Backup File | Delete Excel.qat File | Run Office Quick Repair |
|---|---|---|---|
| Best For | Restoring a known good configuration quickly | Fixing corruption when no backup exists | Resolving deeper program file issues |
| Data Loss | None, restores previous setup | Loses all customizations, requires manual rebuild | Typically preserves user settings |
| Time Required | Less than one minute | Five minutes plus time to rebuild toolbar | Five to fifteen minutes plus system restart |
| Complexity | Simple, uses built-in menu | Moderate, requires navigating system folders | Simple, guided by Windows installer |
You can now recover your Quick Access Toolbar when it resets unexpectedly. Start by creating a backup of your current setup using the Import/Export feature in Excel Options. If the problem persists, the Office Quick Repair tool is a reliable next step. For advanced control, you can export your ribbon and toolbar customizations together to a single file for a complete interface backup.