Fix Excel Error After Installing Office 2016 Update KB5002653
Question details
Users experience Excel add-in failures, specifically missing Analysis ToolPak files like ANALYS32.xlsx, immediately following the installation of Office 2016 security update KB5002653.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Trying to use Excel add-ins or the Analysis ToolPak after applying a recent Office 2016 security patch.
- Observed behavior
- Excel displays an error stating "Sorry, we couldn't find C:\Program Files\Microsoft Office\Office16\Library\Analysis\ANALYS32.xlsx" and prevents add-ins from running.
Verify whether your Microsoft Office 2016 installation is 32-bit or 64-bit, and check with your IT administrator regarding policies on uninstalling system security patches.
Apply the Latest Microsoft Patch for KB5002653
Microsoft frequently releases subsequent hotfixes to address known bugs introduced by previous security updates like KB5002653.
Since this is a documented bug affecting both 32-bit and 64-bit Office 2016 installations, Microsoft releases subsequent patches to restore add-in functionality. Applying the official fix is the safest way to resolve the missing ANALYS32.xlsx error without compromising system security.
Navigate to the Microsoft Community forums and locate the official thread titled "Unable to run Excel add-ins after KB5002653 latest patch" to find the direct download link for the hotfix.
Download the official update package that corresponds to your specific Office 2016 architecture (32-bit or 64-bit).
Run the installer, restart your computer, and open Excel. Attempt to load the Analysis ToolPak to confirm the add-in now works properly.

Temporarily Uninstall the KB5002653 Update
Removing the problematic update will immediately restore your Excel add-in functionality until a permanent fix is deployed by your IT department.
Use WPS Office for a Stable, Add-in Friendly Spreadsheet Experience
Avoid unexpected downtime caused by Office update bugs. WPS Spreadsheet is a free, highly compatible alternative to Microsoft Excel that supports common formulas, data analysis, and advanced spreadsheet features without the instability of recent security patches.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your PC.
- 2. Install the software: Run the installer and follow the quick setup wizard to install the suite.
- 3. Open your files: Right-click your problematic .xlsx files and choose 'Open with WPS Spreadsheets' to seamlessly continue your work.

Frequently Asked Questions
Why is ANALYS32.xlsx missing after the Office 2016 update?
The KB5002653 security update altered or inadvertently corrupted the registry paths or file associations for the Analysis ToolPak add-in in Office 2016, causing Excel to fail when locating the ANALYS32.xlsx file.
How do I check if my Office 2016 is 32-bit or 64-bit?
Open Excel, click on 'File' > 'Account', and click the 'About Excel' button. A new window will open displaying whether your installation is 32-bit or 64-bit at the top.
Can I perform data analysis without the Analysis ToolPak?
Without the Analysis ToolPak, advanced statistical features like ANOVA, Histograms, and Regression are not natively available in the Excel Data ribbon. You will need to rely on manual complex formulas or resolve the add-in error to restore these capabilities.




