4 Ways to Fix Excel Toolbar Not Working in Windows

Pankil is a Civil Engineer turned freelance writer. Since his arrival at Guiding Tech in 2021, he delves into the world of how-tos, and troubleshooting guides for Android, iOS, and Windows. Besides his new-found love for mechanical keyboards, he’s a disciplined footfall fan and loves international travel with his wife.

Fix 1: Reset Toolbar Customizations

On Microsoft Excel, you can customize the toolbar to quickly access your frequently used commands. However, a startup issue with these custom preferences could make theExcel toolbar unresponsiveon your computer. You can reset the toolbar customization in Excel to see if that gets the toolbar working.

Step 1:Open Microsoft Excel and click theFilemenu at the top.

Step 2:SelectOptionsfrom the sidebar.

Step 3:In theQuick Access Toolbartab, clickResetnext to Customizations and selectReset all customizations.

Step 4:HitYesto confirm.

Fix 2: Rename the Excel Toolbar File

If resetting the Excel toolbar proves ineffective, the Excel file containing your toolbar settings is likely corrupt. In that case, you must rename the Excel toolbar file on your computer. This will force Excel to create a new toolbar file, effectively fixing any issues.

Step 1:Press theWindows key + Rto open the Run dialog box. Type the following command in the text box and pressEnter.

Step 2:In the File Explorer window, you should see a file namedExcel15.xlborExcel.xlb, depending on your Office version. Right-click on it and click therename icon.

Step 3:Rename the file toOldExcel15.xlborOldExcel.xlb.

Restart your computer and use the toolbar again.

Fix 3: Start Excel in Safe Mode

Sometimes, a malfunctioning Excel add-in can cause the program to run into issues and behave strangely. You can verify this by opening Excel in safe mode, allowing it to run without add-ins.

To open Excel in safe mode, press theWindows key + Rto access the Run dialog. Typeexcel -safein the Open field and pressEnter. If the toolbar works as expected in safe mode, disable all the add-ins and enable them individually to find the one causing the issue.

Step 1:In Excel, click theFilemenu at the top left corner and selectOptions.

Step 2:In theAdd-instab, selectCOM Add-insin the Manage drop-down menu and click theGobutton next to it.

Step 3:Clear all the checkboxes to disable your add-ins and clickOK.

Restart Excel after disabling add-ins and re-enable them one by one. Try using Excel after enabling each add-in to determine which one is causing the issue. After identifying the problematic add-in, consider removing it to prevent further issues.

Fix 4: Run the Office Repair Tool

Microsoft offers a useful repair tool for fixing issues with Office apps. This tool can automatically scan andfix issues with Microsoft Excelthat may have caused the toolbar to stop working. Here’s how to run it.

Step 1:Press theWindows key + Rshortcut to open the Run dialog box. Typeappwiz.cplin the box and pressEnter.

Step 2:In the Programs and Features window, locate and select theMicrosoft Office producton the list. Then, click theChangebutton at the top.

Step 3:Select theOnline Repairoption and clickRepair.

Was this helpful?

Last updated on 22 April, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Windows

7 Ways to Fix Low Volume on YouTube Videos in Chrome

5 Ways to Fix Microsoft Word Stuck on Saving

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.