Skip to main content.

UPDATE: Calculation Errors in Excel 2007

October 13, 2007 -- Reports emerged in Fall 2007 of calculation errors in Microsoft's newly released Excel 2007 for Windows (both for Vista and Windows XP). Microsoft released a patch for the problem on October 9 -- you can find information on the "hot fix" at:

http://support.microsoft.com/kb/943075

Prior to patching, Excel 2007 reports the result of the formula

=850*77.1 as 100000

rather than the correct 65535 (this error has been confirmed in 2007 version of Excel that has been distributed at UMW).

Users are reporting that this error extends to any multiplication/division combination that should yield 65535. (such as =5.1*12850 =10.2*6425, = 850/(1/77.1) and even =SUMPRODUCT(850,77.1,2,0.5) )