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.

The Problem
” 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).

Advertisements

One Response to “Microsoft fixes Excel calculation bug”

  1. Upma Says:

    I saw a comment by the MS excel team member on slashdot “Excel multiplication bug has been reported to us”. Its good that they fixed it soon and combined with the windows update rather than a separate patch.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: