Office Settings & Configuration

Fix Excel Analysis32.xll and ATPVBAEN.xlam Add-In Errors

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Resolve Excel errors reporting that Analysis32.xll or ATPVBAEN.xlam is damaged after an Office update or installation.

Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
Using Excel and its Analysis ToolPak statistical or engineering analysis features after installing or updating Office.
Observed behavior
Excel reports that Analysis32.xll or ATPVBAEN.xlam is damaged.
Before you start

Check whether your workbooks or VBA procedures use Analysis ToolPak functions or tools. Disabling the add-ins may temporarily prevent those features from working.

Solution 1Recommended

Disable the affected Analysis ToolPak add-ins and restart Excel

Use this approach to stop the add-in errors while you check for Office updates.

1
Open Excel add-in settings

In Excel, select File > Options > Add-ins.

2
Disable the affected add-ins

At the bottom of the Add-ins window, choose Excel Add-ins in the Manage list and select Go. Clear the Analysis ToolPak and Analysis ToolPak - VBA check boxes if they are selected, then select OK.

3
Restart and test Excel

Close Excel, reopen it, and check whether the error appears again.

4
Check for Office updates

In Excel, select File > Account > Update Options > Update Now if that option is available. After updating, restart Excel and check for the error.

5
Re-enable add-ins if needed

Return to File > Options > Add-ins > Manage: Excel Add-ins > Go. Select the add-ins you need, choose OK, and test the affected workbook or analysis tool.

Disable the affected Analysis ToolPak add-ins and restart Excel
Check workbook dependencies: Standard VBA macros do not normally require these add-ins, but macros that call ToolPak procedures and workbooks that rely on ToolPak features may need them enabled.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move between office suites. It does not repair Excel add-in errors.

Open and edit Microsoft Excel XLSX and XLS filesUse spreadsheet formulas and data-analysis features in WPS SpreadsheetsNavigate a familiar interface when moving from Microsoft OfficeUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What are Analysis32.xll and ATPVBAEN.xlam used for?

They are associated with Excel's Analysis ToolPak and its VBA support, which provide statistical and engineering analysis features.

Will disabling the Analysis ToolPak stop my macros from working?

Standard VBA macros generally do not need the ToolPak. However, macros that call ToolPak procedures may stop working until the relevant add-in is enabled again.

Where can I turn the Analysis ToolPak back on?

In Excel, go to File > Options > Add-ins, choose Excel Add-ins in the Manage list, and select Go. Check the add-ins you need and select OK.

What should I do if the error returns after re-enabling the add-ins?

Disable the affected add-ins again through File > Options > Add-ins > Manage: Excel Add-ins > Go. Check File > Account > Update Options for available updates, then test the add-ins again after updating.

Can WPS Office repair these Excel add-in files?

No. WPS Office is an alternative for working with spreadsheets, but it does not repair Microsoft Excel's Analysis ToolPak add-ins.