Fix Excel Add-In 'Object Doesn't Support getitem' Error After Update
Question details
An Excel add-in utilizing macros and advanced formulas fails with a getitem property error after updating Microsoft 365.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using an Excel add-in containing macros and advanced formulas after receiving the Microsoft 365 version 2306 update.
- Observed behavior
- The add-in stops working and displays an error stating that the object does not support the getitem property or method.
Save all your current workbook progress and verify your current Microsoft 365 channel and build version in the Account settings before applying any updates.
Update Microsoft 365 to Version 2307 or Later
This specific getitem error was a known bug in version 2306 and has been officially resolved in build 2307.
Microsoft identified the VBA getitem property failure as an issue specific to the 2306 release. Installing the subsequent update patch restores normal macro and add-in functionality without requiring code changes.
Launch Excel, click on 'File' in the top-left corner of the window, and select 'Account' from the left sidebar menu.
Click on the 'Update Options' button located next to the Office Updates section, then select 'Update Now' from the drop-down menu.
Wait for the update to download and install. Once completed, restart Excel and check the Account page again to verify your version is now 2307 or newer.
Contact the Add-in Developer or Microsoft Support
If you cannot update your Office build or the error persists in newer versions, the add-in code may need adjustment.
Try WPS Office for Stable Spreadsheet and Macro Operations
If frequent Office updates disrupt your workflow or break your custom VBA macros, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that handles advanced formulas and VBA macros with excellent stability, all for free.
Frequently Asked Questions
Why did my Excel add-in suddenly stop working after an update?
Microsoft 365 updates occasionally introduce temporary software bugs. The version 2306 update specifically caused an issue with the getitem property in VBA, breaking certain macros, custom formulas, and third-party add-ins until patched in version 2307.
How can I check my current Microsoft Excel build version?
Open Microsoft Excel, click on 'File', select 'Account' at the bottom left, and look under the 'About Excel' section on the right side of the screen. You will see your exact version and build number listed.
Can I roll back Microsoft 365 to a previous version to fix the macro error?
Yes, you can use the Microsoft Office Deployment Tool to revert your installation to an earlier, stable build (such as version 2305) to restore add-in functionality until the version 2307 patch is officially released to your specific update channel.
