How to View the Exact Microsoft 365 Office Updates Installed
Question details
The user wants to view a detailed local history of installed Microsoft 365 Office updates and their installation dates to investigate a recent Excel VBA macro error.
- Product
- Microsoft 365 Apps / Excel
- Device & OS
- not provided
- Scenario
- Investigating a VBA macro type mismatch error involving Evaluate("NA()") that started occurring recently, which the user suspects was caused by a Microsoft 365 Excel update.
- Observed behavior
- Microsoft 365 does not provide a detailed, per-update history interface like Windows Update. Additionally, directly comparing a cell value to Evaluate("NA()") produces a type mismatch error when the cell does not contain an #N/A error.
Before troubleshooting, ensure you have saved a backup of your Excel macro-enabled workbook and check your current Office build number on the Excel Account page.
Check Current Microsoft 365 Build and Event Logs
Since Office does not natively list a detailed update history in the app, you can check the current build version and use Windows Event Viewer for installation logs.
Microsoft 365 updates by replacing the suite build rather than installing separate cumulative patches. Therefore, there is no standard user interface that lists every previously installed Office update.
Open Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom left menu. Under 'Product Information', note the Version and Build number next to 'About Excel'.
Press the Windows key + X on your keyboard and select 'Event Viewer' from the context menu.
Navigate to 'Windows Logs' > 'Application'. Click 'Filter Current Log' on the right pane, and check for Office-related update events (look for Source: Microsoft Office 16 Alerts or Office click-to-run service logs).
Fix the VBA Type Mismatch Error with Evaluate("NA()")
Resolve the VBA error caused by directly comparing a cell value to an error type, which occurs regardless of Office updates when the cell does not contain #N/A.
Try WPS Office for Stable Spreadsheet Management and VBA Support
If you are frustrated with unexpected behavior changes in Microsoft 365 updates, consider switching to WPS Office. It offers a stable, lightweight environment with excellent Microsoft Excel compatibility and robust macro support.
Frequently Asked Questions
Can I roll back a Microsoft 365 update if it causes issues with my macros?
Yes, you can revert to an earlier version of Microsoft 365 Apps. This typically requires using the Office Deployment Tool (ODT) and specifying your desired previous target version in the configuration XML file.
Why did my VBA macro suddenly start returning a type mismatch error?
A type mismatch often happens when VBA tries to compare conflicting data types. If your cell previously held an #N/A error and your macro checked for that error, it worked. If the cell's data changed to a standard text or number value, comparing it directly to an error object triggers a mismatch.
Where can I see all previously installed Microsoft Office updates?
Microsoft 365 click-to-run installations update by replacing the entire build rather than installing cumulative patches. Because of this architecture, a granular per-update history is not available in the Office UI. You must rely on Windows Event Viewer logs or IT deployment software.
