Tag Archives: Microsoft Excel

KB2597166 – Microsoft Excel 2010 Security Update FAIL

** UPDATE-3 28 August 2012 ** Our internal tests show KB2598378 does in fact fix the issue.  Be sure to use the correct version (32 or 64 bit) depending on your Office version (NOT Windows).

** UPDATE-2 23 July 2012 ** Microsoft says this issue has been fixed in KB2598378.  We’re testing the fix at our shop now; let’s hope the second time’s the charm…

** UPDATE 17 June 2012 ** It appears that Microsoft has released a hotfix that resolves the issue (KB2598144).  We have NOT tested this hotfix, so I can’t say whether it works or not.  If anyone out there has, please let me know your results…

MS12-030 (KB2597166), was released on 8 May 2012.  This magical piece of crap will cause your Excel 2010 application to BREAK when users try to sort large data sets.  Indications include:

  • Large Operation warning box: “The operations you are about to perform affects a large number of cells and may take a significant amount of time to complete.”
  • Error: “Excel cannot complete the task with available resource.  Choose less data or close other applications.

We were able to recreate by selecting all cells and attempting a sort operation.

Word on the street is that Microsoft is aware of the issue but DOES NOT have a fix.  Their “workaround” is to not select the entire sheet prior to sorting.  My advice: DON’T INSTALL THE UPDATE (unless you like a bunch of angry users chasing you with pitchforks)…

If you happened to have already installed this patch, you can remove it using the following command line (helpful if you use automation):

msiexec /package {90140000-0011-0000-0000-0000000FF1CE} /uninstall {B76D8C6D-1F13-42A7-9931-D7504CB89D6D} /qn