Office Settings & Configuration

Fix Excel Quick Access Toolbar Buttons Disappearing After Restart

Steve KSteve K Nov 2, 2026 870 views

Question details

The user is unable to save customizations made to the Excel Quick Access Toolbar, as the settings reset to default every time the application is closed and reopened.

Fix Excel Quick Access Toolbar Buttons Disappearing After Restart
Product
Microsoft Excel 365
Device & OS
Windows
Scenario
Adding custom shortcuts and features to the Quick Access Toolbar to improve daily workflow efficiency.
Observed behavior
Customized Quick Access Toolbar buttons disappear after Excel is restarted because the application fails to update or create the Excel.officeUI configuration file.
Before you start

Verify that your Windows user account has Administrator privileges, and open the Task Manager (Ctrl+Shift+Esc) to ensure all background instances of Microsoft Excel are completely closed before modifying system configuration files.

Solution 1Recommended

Run Excel as Administrator to Grant File Permissions

Running Excel with elevated privileges ensures the application has the necessary file system rights to create and update the Office UI configuration file in your user directory.

Often, restrictive local permissions or group policies prevent Excel from creating the 'Excel.officeUI' file when launched normally. Running the application as an administrator bypasses these restrictions for the active session.

1
Search for Excel

Click the Windows Start menu icon on your taskbar and type 'Excel' into the search bar.

2
Launch as Administrator

Right-click the Microsoft Excel application icon from the search results and select 'Run as administrator' from the context menu.

3
Customize the Toolbar

Once Excel is open, click the drop-down arrow on the Quick Access Toolbar and add your preferred command buttons.

4
Restart to Verify

Close the Excel application completely, then reopen it normally from the Start menu to verify that your customized buttons remain visible.

Run Excel as Administrator to Grant File Permissions
Permissions Applied: If this successfully saves the toolbar, the Excel.officeUI file has now been successfully created in your AppData folder.
Free Microsoft Office alternative

Enjoy a Stable and Customizable Workspace with WPS Office

Tired of missing toolbars and persistent configuration errors in Microsoft Excel? Switch to WPS Office Spreadsheet for a stable, lightweight, and highly reliable alternative that seamlessly saves your personal interface preferences.

  1. 1. Download and Install: Download WPS Office from the official website and install it on your Windows PC.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and locate the Quick Access Toolbar at the top left of the interface.
  3. 3. Customize Your Tools: Click the small drop-down arrow next to the toolbar and select 'More Commands' to easily add or remove specific features.
Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Reliably saves Quick Access Toolbar customizations without permission errors.Lightweight application design that consumes fewer system resources.Free to use with a familiar user interface that makes transitioning effortless.
microsoft office alternative - wps office

Frequently Asked Questions

Where does Excel store my Quick Access Toolbar customizations?

Excel stores your Quick Access Toolbar configurations in a file named Excel.officeUI. Depending on your system configuration, this file is typically located in either C:\Users\[YourUsername]\AppData\Local\Microsoft\Office or C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Office.

Why do my customized buttons keep disappearing after restarting Excel?

This happens when Excel is prevented from updating or generating the Excel.officeUI file upon exit. This restriction is usually caused by inadequate user file permissions, overly restrictive antivirus software, or corrupted Office profiles.

Can I transfer my Quick Access Toolbar settings to a new computer?

Yes. You can use the 'Import/Export' feature directly within the Excel Options menu to save a configuration file, or you can manually copy the Excel.officeUI file from your current computer's AppData folder and paste it into the corresponding folder on your new computer.