Fix Excel 2016 VBA Runtime Error 440 When Calculating a Worksheet
Question details
The user needs to resolve a VBA runtime error that occurs when a macro calculates an Excel worksheet.
- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- A VBA macro calculates a worksheet, potentially after a Windows or Office update.
- Observed behavior
- Excel may display Runtime Error 440 or error 0x80010108, indicating that an object was disconnected from its clients. Excel may then crash and restart.
Note the exact error message, the macro action that triggers it, and any recent Windows or Office updates. Close Excel and other Office applications before starting a repair.
Repair Microsoft Office to Troubleshoot Excel Runtime Error 440
Use Office repair to check the installation, starting with Quick Repair and then trying Online Repair if needed.
Press Windows key + I, then select Apps to open the list of installed applications.
Find Microsoft Office in the app list, select it, and choose Modify. Confirm any Windows permission prompt.
Select Quick Repair, choose Repair, and follow the prompts. Reopen Excel and run the macro again.
If the error continues, return to Apps, select Microsoft Office, and choose Modify > Online Repair > Repair. An internet connection is required. Reopen Excel and test the macro after the repair.

Report the Persistent VBA Error to Microsoft
Use this option if Office repair does not stop the error or Excel continues to crash.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and Excel format compatibility for an easier move between applications. It does not repair Microsoft Excel, and VBA macro compatibility may vary.

Frequently Asked Questions
What does error 0x80010108 mean in an Excel macro?
It indicates that an object was disconnected from its clients. In this scenario, it can appear during a VBA worksheet calculation and may be followed by an Excel crash.
Should I run Quick Repair or Online Repair first?
Start with Quick Repair through Windows Settings > Apps > Microsoft Office > Modify. If the error remains, return to the same menu and run Online Repair with an internet connection.
What can I do if Online Repair does not fix the error?
In Excel, use File > Feedback > Send a Frown if available, or contact Microsoft Support. Include the error codes, the macro action that triggers the issue, recent updates, and the repairs you tried.
Will WPS Office fix the VBA error in Microsoft Excel?
No. WPS Office is an alternative for working with spreadsheets, not a repair for Excel. Excel file formats are supported, but VBA macro compatibility may vary.




