Fix Excel Analysis32.xll and ATPVBAEN.xlam Add-In Errors
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.
Check whether your workbooks or VBA procedures use Analysis ToolPak functions or tools. Disabling the add-ins may temporarily prevent those features from working.
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.
In Excel, select File > Options > 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.
Close Excel, reopen it, and check whether the error appears again.
In Excel, select File > Account > Update Options > Update Now if that option is available. After updating, restart Excel and check for the error.
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.

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.

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.




