Users with Microsoft Office 2010 began to experience issues with Excel after installing Windows Update KB3178690. Any calculation triggered by code or user interaction caused application to freeze or crash. Operations such as row and column deletion, using excel add-ins and SQL statements all result in errors. Running Excel in safe mode and disabling add-ins don’t work either.
To fix this issue, we simple have to remove the KB3178690 update as a temporary fix and also installing the a new update which fixes the issue.
Method 1: Uninstalling Windows Update KB3178690
This update caused the whole issue. Removing it will fix the issue temporarily. Make sure you disable automatic updates for the mean time to prevent Windows from downloading it again.
- Press Win + I to open Windows settings.
- Select Update & Security and navigate to Update history > Uninstall updates.
- A Control Panel window will open showing all installed updates. Click on the “Search Installed Updates” search bar at the upper-right and type KB3178690 .
- Double-click on KB3178690 in the search result and click OK to confirm the update removal.
- Reboot your PC and try running performing operations in Excel 2010 again.
Method 2: Applying Windows Update
Microsoft has fixed this bug with the update KB3191855. You don’t need to uninstall the faulty update in method 1 for this.
- Press Windows + I key to open Windows settings.
- Select Update & Security and select Check for Updates. Windows will check for updates and begin downloading pending updates. If automatic updates are disabled, make open the list of pending updates and install update KB3191855.
- Reboot your PC and try performing calculations in Excel 2010 again.