'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Quick Access Toolbar Customization Not Saving
Question details
The user is unable to permanently remove default commands from the Excel Quick Access Toolbar, as the application fails to save the customization preferences.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Modifying the Quick Access Toolbar to optimize personal keyboard workflows and remove unnecessary default buttons.
- Observed behavior
- Excel automatically restores default commands such as AutoSave, Save, Undo, and Redo upon restart after the user has manually removed them.
Before attempting to reset your configuration files, manually back up any custom macros or ribbon settings by exporting them from the Excel Options menu, as resetting user data will revert these to factory defaults.
Install the Latest Microsoft 365 Updates
Since this toolbar reset behavior is a known bug in certain versions of Excel, updating the software often provides a permanent patch.
Microsoft frequently releases patches for user interface bugs. Ensuring your Office installation is on the latest build channel is the safest and most effective first step.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Account' from the bottom left menu.
Under the 'Product Information' section, click on the 'Update Options' drop-down button and choose 'Update Now'.
Allow Microsoft 365 to download and install any pending updates. Once complete, restart Excel, remove a command from the Quick Access Toolbar, and reopen the app to verify if the change persists.
Reset Excel User Data via Command Line
If updating does not resolve the problem, the configuration file storing your toolbar settings may be corrupted. You can force Excel to rebuild it.
Customize the Quick Access Toolbar Easily in WPS Office
If Excel continues to lose your customizations due to recurring bugs, consider using WPS Spreadsheet. WPS Office offers a highly stable and compatible environment where you can freely customize your Quick Access Toolbar to match your preferred keyboard workflows without unexpected resets.
- 1. Launch WPS Spreadsheet: Download and open WPS Office, then click 'Spreadsheet' to start a new or existing workbook.
- 2. Access Toolbar Settings: Click the small drop-down arrow located at the far-right end of the Quick Access Toolbar at the top of the window.
- 3. Open More Commands: Select 'More Commands' from the drop-down menu to open the customization dialog box.
- 4. Customize and Save: Add or remove your preferred tools, arrange their order, and click 'OK'. Your preferences will be saved securely across all future sessions.
Frequently Asked Questions
Where is the Quick Access Toolbar settings file located on Windows?
The customizations for the Quick Access Toolbar are typically stored in a file with an '.officeUI' extension. You can find this file by navigating to '%localappdata%\Microsoft\Office' in your Windows File Explorer.
Can I back up my Quick Access Toolbar customizations before resetting Excel?
Yes. Go to 'File' > 'Options' > 'Quick Access Toolbar'. In the bottom right corner, click on the 'Import/Export' button and select 'Export all customizations'. You can save this file and import it later.
Why does the AutoSave toggle specifically keep reappearing on my toolbar?
The reappearance of the AutoSave toggle is a recognized glitch in certain Microsoft 365 update channels, where the default cloud integration buttons forcibly override local user UI customizations upon application restart.
