Microsoft fixes Excel calculation bug
October 10, 2007
I’m pleased that Microsoft responded quickly to the demands of the online community. They have made available patches to the calculation problem which involves calculations around the number 65,535 and 65,536 in Excel 2007 and Excel services.
Here’s the take of the problem from the Excel and Excel services team blog.
” This issue was introduced when we were making changes to the Excel calculation logic in the Office 2007 time frame. Specifically, Excel incorrectly displays the result of a calculation in 12 very specific cases (outlined below). The key here is that the issue is actually not in the calculation itself (the result of the calculation stored in Excel’s memory is correct), but only in the result that is shown in the sheet. Said another way, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains “=850*77.1”, and A2 contains “=A1*2”, A2 will return the correct answer of 131,070).”
The good part is that they will be pushing this out with Windows update, which mean you can have the potential fix without any explicit download. The fix will also be available along with the Service Pack 1 (SP1) for Office 2007 (official date of release for which has not yet been announced).