Karlston Posted March 18, 2017 Share Posted March 18, 2017 I’m seeing lots of reports about Excel 2010 freezing after applying Tuesday’s security patch KB 3178690. On the Microsoft Answers forum, poster gneJim says: I have had to remove this update from approx. 4 machines (3x Win7, 1x Win10) this morning as Excel 2010 kept crashing out when trying to update SQL queries. (D-N) says: Further on the cut and paste issue. We tested other excel procedures to see if anything else other than the cut and paste would cause a problem. We discovered that if you use the bottom right black cross in a range of cells and drag it down to copy the range into new cells, excel instantly locked up. No macro involved. These results didn’t happen to all sheets, only very large workbooks (19 mb). On the TechNet Excel forum poster Steve Stretch says: Since the update 2 days ago (KB3178690). The following section of code now freezes Excel. I guess the application may be churning over and over… This code has worked for 10 years without a hitch, now all 25 clients still running Excel 2010 have reported this freeze error. Microsoft acknowledges the problem, both in the KB article, and on the Office support forum. Known issues in this security update After you install this security update, Excel 2010 may crash or hang (stop responding or freeze) when calculations are performed in a workbook. The calculations may be triggered either by code or by user interaction. Microsoft is researching this problem and will post more information in this article when the information becomes available. At this point, the only known solution is to uninstall the security patch. Source: Excel security patch MS17-014 for Excel 2010, KB 3178690, triggering crashes (AskWoody.com) Link to comment Share on other sites More sharing options...
Karlston Posted March 20, 2017 Author Share Posted March 20, 2017 Updated in an InfoWorld article... Botched Windows patch KB 3178690 freezes, crashes Excel 2010 Microsoft admitted the problem and has stopped forcing the bad patch through automatic update, but hasn’t pulled the update Credit: Thinkstock If you use Excel 2010 and your spreadsheets are suddenly acting strange—freezes, crashes for no apparent reason—you likely have Windows Automatic Update turned on. Last Tuesday, as part of its usual Patch Tuesday celebrations, Microsoft pushed a patch, KB3178690, that causes recalculations in Excel 2010 to freeze or crash the program. The only solution at this point: Uninstall the patch. Poster gneJim first raised the alarm on Thursday on the Microsoft Answers forum: KB3178690 causing excel 2010 to crash I have had to remove this update from approx. 4 machines (3x Win7, 1x Win10) this morning as Excel 2010 kept crashing out when trying to update SQL queries. By Friday night, Microsoft employee Freya had confirmed the problem: Issue summary: After installing KB3178690 in Excel 2010, calculation triggered either by code or user interaction in the workbook may result in a hang or crash. We released KB3178690 on March 14. We are urgently working on a fix and I will keep this thread updated when we have more information. Bewildered Excel 2010 users have continue to wonder throughout the weekend why their spreadsheets are suddenly crashing. To date, there's no fix for the problem, other than uninstalling the patch. Microsoft has graciously “unchecked” the update, so it doesn’t continue to install automatically on Windows 7 and 8.1 systems. Those of you running Windows 10 will have to uninstall the patch, then take the additional step of using the wushowhide utility to prevent the patch from being installed again. As of Monday morning, the patch is still available in the Update Catalog and is being distributed as an unchecked Important update. But oddly—without explanation—the Catalog version is dated Friday, March 17. It’s hard to imagine how this automatically updated security patch got through Microsoft's testing. On the other hand, this demonstrates the advantage of releasing patches separately. If the Office 2010 patches had been bundled--as is currently the case with Windows 7, 8.1, and 10—you would’ve been forced to back out the entire bundled batch to fix this one blunder. Discussion continues on the AskWoody Lounge. Source: Botched Windows patch KB 3178690 freezes, crashes Excel 2010 (InfoWorld - Woody Leonhard) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.