VBA & Macro Problems

Fix Excel 2016 VBA Runtime Error 440 When Calculating a Worksheet

Muhammad TalhaMuhammad Talha Nov 22, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Windows app settings

Press Windows key + I, then select Apps to open the list of installed applications.

2
Select Microsoft Office

Find Microsoft Office in the app list, select it, and choose Modify. Confirm any Windows permission prompt.

3
Run Quick Repair

Select Quick Repair, choose Repair, and follow the prompts. Reopen Excel and run the macro again.

4
Try Online Repair

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.

Repair Microsoft Office to Troubleshoot Excel Runtime Error 440
Repair may not resolve every case: Online Repair did not resolve the error in one reported case. If the problem persists, report the details to Microsoft.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsUse a free, lightweight alternative for everyday spreadsheet workContinue working with worksheet data while troubleshooting Excel
microsoft office alternative - wps office

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.