You are here How to restore lost in Add-In A-tools toolbar in Microsoft Excel

Query, Share and Manage Excel workbooks on LAN, Internet

How to restore menu A-tools in Microsoft Excel

1. Reasons

In many cases, when we suddenly turn off the Excel file incorrectly processes, may be due to power outages or crashes, ... Toolbar Add-in A-Tools will be lost temporarily. This article guides you how to restore the toolbar Add-in A-Tools temporarily lost in Microsofts Excel.

2. Restore menu A-Tools in Microsoft Excel

When reopen the Excel file, we will receive the following message, we must select button "No" to keep the toolbar Add-in A-Tools, if we choose "Yes", the toolbar Add-in A-Tools will be lost.

In that case, we have 2 ways to overcome.

 Way 1:

  • Step 1: Go to "File" => Select "Option":

  • Step 2: Click on "Add-ins", in the "Manage", pointing combo box choose "Disabled Items".

  • Step 3: In the "Disabled Items", select Add-in displayed, then click "Enable".

  •  Step 4: Turn off and reopen file Excel, check the Add-in A-Tools has been restored or not.

Method 2:

  • Step 1: Close file excel.
  • Step 2: At the desktop, choose to “Enable Add-ins in Excel” in yellow exclamation icon

  • Step 3: Double-click to display the billboards, we click "Enable All Add-ins", after receiving the notice has added add-ins, we turn off notifications and re-open the file Excel to check the results.

Hopefully the article will help you in the process of using the Add-in A-Tools.

Thanks all.

Nguyen Thi Van