Excel Toolbar not working [Fix]

This submit explains learn how to repair Excel Toolbar whether it is not working in Home windows 11/10. Excel is without doubt one of the hottest spreadsheet instruments utilized by greater than half a billion folks worldwide. Whereas working with Microsoft Excel, just a few customers have reportedly confronted an odd error the place the icons on the toolbar cease responding to the mouse. For instance, after they attempt to click on on the ‘File’ menu to entry the ‘Save’ or ‘Print’ command, the mouse click on doesn’t work. Additionally, the instructions are not highlighted when the mouse pointer passes over them. In case you’re going through the same problem and need to work out learn how to repair the issue, then hold studying this submit.

Repair Excel Toolbar not working

The Excel toolbar might not be working in your Home windows 11/10 PC on account of varied causes. One major motive is a corrupt Excel toolbar file. Different causes could possibly be broken system recordsdata, custom-made add-ins, or conflicting third-party apps.  

For many of the customers, the difficulty subsides after they resize this system window utilizing the mouse or utilizing the maximize/decrease icons. For some, the difficulty resolves after they click on anyplace within the desktop space after which once more click on on the spreadsheet. Nonetheless, these are simply non permanent fixes. In an effort to resolve the difficulty completely, we advocate utilizing the next options: 

1. Reset toolbar settings.
2. Rename the corrupt toolbar file.
3. Troubleshoot Excel in Secure mode.
4. Restore Microsoft Excel.
5. Troubleshoot in a Clear Boot state.

Allow us to see these intimately.

1] Reset toolbar settings

Begin by resetting the customizations you’ve made to the Excel toolbar.  

1. Go to File > Extra… > Choices. This may open the Excel Choices window.
2. Click on on Customise Ribbon within the left panel.
3. Choose All Tabs within the Customise the Ribbon dropdown on the right-hand aspect.
4. Make sure that all of the choices are chosen within the checklist field simply beneath the dropdown.
5. Click on on the Customizations dropdown beneath the checklist field and click on on the Reset all customizations possibility. 
6. Click on on the Sure possibility within the alert that seems.

This may delete all of the customizations for Ribbon and Fast Entry toolbar tabs and reset the default settings for this system. When you do that, attempt utilizing Excel once more and see if it fixes the difficulty.

2] Rename the corrupt toolbar file

If the difficulty is because of a corrupt toolbar file, fixing it might resolve the issue. Once you rename a corrupt toolbar file, Excel rebuilds a brand new toolbar when it restarts.

1. Open File Explorer and copy-paste the next within the handle bar: %AppDatapercentMicrosoftExcel.
2. Find the Excel.xlb or Excel15.xlb file (for Excel 2013, 2016, and 2019/365).
3. Proper-click on the file and choose Present extra choices.. > Rename.
4. Rename the file as Excel.xlb.outdated or Excel15.xlb.outdated and press the Enter key.
5. Reboot your PC.
6. Restart Excel and see if the difficulty is fastened.

Additionally Learn: Finest Excel Restore Instruments & Strategies to restore corrupted Excel file.

3] Troubleshoot Excel in Secure mode

If the difficulty persists, attempt beginning Microsoft Excel in Secure Mode. Secure mode is a diagnostic mode during which this system begins with primary options. Secure mode checks for corrupted useful resource recordsdata, registry entries, or templates. It additionally disables all of the add-ins and menu customizations, so that you could be allow them one after the other (manually) to establish the problematic merchandise.

1. Go to File > Extra… > Choices > Add-ins.
2. Within the Handle dropdown on the backside, choose Disabled objects and click on on the Go button.
3. From this checklist, choose one merchandise and allow it. See if it causes the issue. If it doesn’t trigger the issue, allow one other merchandise. Maintain doing this till you discover the problematic merchandise. In case you discover one, take into account eradicating it.
4. Shut Excel to exit the protected mode.

4] Restore Microsoft Excel

Subsequent, restore the Microsoft Excel program utilizing Microsoft’s Fast Restore/On-line Restore device. This may try and restore any corrupt program recordsdata if Excel is not working appropriately.

1. Shut Microsoft Excel.
2. Ensure you’re related to a secure web connection.
3. Press the Win key in your keyboard.
4. Choose Settings.
5. Click on on the Apps possibility within the left panel.
6. Then click on on Put in Apps in the suitable panel.
7.  Within the search bar on prime, sort ‘microsoft office’
8. The search outcomes will present the Workplace model put in in your system.
9. Click on on the choices icon (three horizontal dots) subsequent to it and choose Modify.
10. Choose Sure within the UAC immediate that seems.
11. Within the window that seems, choose the On-line Restore possibility and click on on the Restore button. That is relevant to a Click on-to-run primarily based set up. In case you have an MSI-based set up, choose Restore after which click on on Proceed within the Change your set up window.
12. Comply with any on-screen directions and look forward to the restore course of to complete.
13. Restart Excel and see if the difficulty is fastened.

Notice: The above course of will restore the whole Workplace suite. In case you have Excel put in as a standalone utility, you’ll be able to seek for it and restore it individually.

5] Troubleshoot in a Clear Boot state

If the above options received’t assist, the basis trigger might lie with some exterior utility slightly than Excel itself. If that’s the case, troubleshooting Home windows in a Clear Boot state might assist establish the conflicting third-party app. 

Solely Microsoft companies are made to run throughout a clear boot in order that the non-Microsoft product that’s inflicting software program conflicts could also be recognized. When you enter the Clear Boot state (by disabling the non-Microsoft companies and startup applications), attempt utilizing Excel once more. If the toolbar works correctly, you’ll be able to relaxation assured the difficulty is with some third-party app or service. Now you must re-enable the companies and startup applications one after the other to pinpoint the issue. As soon as you discover the conflicting app, take into account eradicating it out of your Home windows 11/10 PC.

Hope the above solutions will help resolve the Excel toolbar not working issue. 

How do I allow the toolbar in Excel?

To indicate/cover or restore a lacking toolbar in Microsoft Excel, click on on the Ribbon Show Choices button within the top-right nook of this system window. Then click on on Present Tabs and Instructions possibility. This may present the ribbon in full-view mode, displaying all of the tabs and instructions. You can too use the Ctrl+F1 hotkey to break down/present the ribbon. In case you’re nonetheless not capable of allow it, test the checklist of disabled objects in Excel.

Learn Subsequent: Excel filter not working correctly.