Fix Excel Quick Access Toolbar Customizations Not Saving
Question details
The user needs to keep Excel Quick Access Toolbar customizations after confirming the changes and prevent unwanted controls from returning.
- Product
- Microsoft Excel or Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- The user adds or removes Quick Access Toolbar commands, clicks OK, and may also export or import a customization file.
- Observed behavior
- Quick Access Toolbar changes are not retained, customization file import or export may fail, and Save, Undo, Redo, or AutoSave controls can reappear unexpectedly.
Check whether the issue occurs in the newer or classic Quick Access Toolbar and note the installed Excel or Microsoft 365 version. Close other Excel workbooks before testing the customization in a new blank workbook.
Update Excel and test the Quick Access Toolbar in a new workbook
Use this first when Quick Access Toolbar changes disappear after clicking OK or unexpected commands return.
This behavior can be related to an Excel or Microsoft 365 interface issue, particularly with the newer Quick Access Toolbar. Updating Excel and testing a blank workbook helps determine whether the problem is application-wide or limited to a workbook or profile.
Open Excel and select File > Account > Update Options > Update Now. Allow Microsoft 365 or Office to install any available updates.
Close every Excel window, wait a few seconds, and reopen Excel so the updated interface and configuration settings load again.
Select File > New > Blank workbook, customize the Quick Access Toolbar, and click OK or Apply. Close and reopen the blank workbook to check whether the changes remain.
Right-click the Quick Access Toolbar, select Customize Quick Access Toolbar, and review the command list. Remove unwanted Save, Undo, Redo, or AutoSave entries, then select OK.
Repair Microsoft 365 or report the Excel interface issue
Use this option when updates, a restart, and a clean workbook do not resolve the customization problem.
Switch to WPS Office for a lightweight office suite with customizable toolbars
If Excel continues to reset Quick Access Toolbar settings, WPS Office provides a free, lightweight alternative with a familiar office interface, customizable controls, and smooth migration for Microsoft Office files. Open existing spreadsheets in WPS Spreadsheets without changing your normal document workflow.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the main application launcher.
- 2. Open an Excel workbook: Select Menu > Open, choose an .xlsx or .xls file, and let WPS Spreadsheets convert it for editing while preserving the workbook format.
- 3. Customize the workspace: Use the WPS Spreadsheets settings and toolbar options to arrange frequently used commands for your preferred workflow.
Frequently Asked Questions
Why do my Excel Quick Access Toolbar changes disappear after I click OK?
The issue may be caused by an Excel or Microsoft 365 interface problem, especially in the newer Quick Access Toolbar. Update Excel, restart it, and test the changes in a new blank workbook.
How can I remove unwanted Undo and Redo buttons from Excel's Quick Access Toolbar?
Right-click the Quick Access Toolbar, choose Customize Quick Access Toolbar, select the unwanted Undo or Redo command in the list, choose Remove, and click OK. If the buttons return, update or repair Microsoft 365.
Why does importing an Excel Quick Access Toolbar customization file fail?
A failed import can result from an Excel interface issue, an incompatible customization file, or a damaged Office installation. Test the toolbar manually in a new workbook, install Office updates, and run Microsoft 365 repair if necessary.
Will repairing Microsoft 365 delete my Excel workbooks?
Office repair targets the Microsoft 365 installation rather than workbook content, but close Excel before starting the repair and follow the repair wizard carefully. Online Repair may require Office to be reconfigured or signed in again.
Can WPS Office fix Excel's Quick Access Toolbar problem?
No. WPS Office cannot repair Microsoft Excel's toolbar configuration, but it can serve as a free alternative for opening, editing, and saving Microsoft Excel .xlsx and .xls files.
