Resolving Excel Show Tabs Error

In Excel, the Show/Hide Tabs command is used to show or hide all sheets in a spreadsheet at once.
However, some users have reported getting a Show tabs error, and today we’re going to show you how to fix this error.

  • Excel show tabs error can be caused by various issues, such as damaged Excel file or the Excel file.
  • To quickly fix this issue, start Excel and check if the issue persists.
  • Another solution is to download and install the latest version of Excel.

Use a VBA solution

  1. Press the F5 key to refresh the Excel tab.
  2. Click the File tab.
    Click the File tab.
  3. Select the Options command.
  4. Then, select the Advanced panel.
  5. Select the Display Calculation Mode option.
  6. Select Iterative.
    Select Iterative.
  7. Press the OK button.

Make a quick repair in Excel

  1. Open Excel, then click on File.
  2. Select Options, then go to the Trust Center.
    Select Options, then go to the Trust Center.
  3. Click on Trust Center Settings, and then on Trust Center Settings.
  4. Scroll down, find the General section, and then click on the Change Settings.
  5. In the Trust Center Settings window, click on Trust Center Maintenance.
  6. Click on Rebuild trust follow these steps:
  7. Select Yes, Do This For My Computer.
    Select Yes, Do This For My Computer.
  8. Select Reenable 40-bit and 56-bit encryption.
  9. Select No, Don’t Reenable 40-bit and 56-bit encryption.
  10. Click on Change Settings, then click on OK.
    Click on Change Settings, then click on OK.

Remove the problematic add-in

  1. If you’re using Excel 2007 or 2010, go to File > Options > Add-ins. If you’re using Excel 2013, go to File > Options > Add-ins and check for the macros enabled box.
  2. Select the check boxes in front of the add-ins you don’t want, and then click OK.
    Select the check boxes in front of the add-ins you don't want, and then click OK.

Disable Show Tabs feature

  1. Right-click the Excel icon on the taskbar.
  2. Choose Excel Options.
    Choose Excel Options.
  3. Then, select Advanced from the left pane.
  4. Uncheck the Show Tabs option.

Clean install Excel

  1. Press Windows Key + X and choose Programs and Features.
  2. Locate Excel on the list, right-click it, and choose Uninstall.
    Locate Excel on the list, right-click it, and choose Uninstall.
  3. Follow the on-screen instructions to complete the removal.
  4. Download the latest version of Microsoft office.
  5. Press Windows Key + X and choose Programs and Features.
  6. Locate Microsoft office on the list, right-click it, and choose Change.
    Locate Microsoft office on the list, right-click it, and choose Change.
  7. Follow the on-screen instructions to complete the installation.
Scroll to Top