Saturday, October 13, 2007
There is a known calculation bug in EXCEL 2007. If you are one of the user of EXCEL 2007, please take serious note on this bug.
Per EXCEL team, this is not really a calculation error but it is just a display error. For example, you type "=77.1*850" in cell A1, then type "=A1+5" in cell A2, you will get 100,000 in cell A1 but 65540 in cell two.
David Gainer has confirmed that this bug was introduced in the EXCEL 2007 version and a fix for this bug is available in below message.
Two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download from the following locations:
KB Articles have been posted as well:
Excel 2007: http://support.microsoft.com/default.aspx/kb/943075/
Excel Services 2007: http://support.microsoft.com/default.aspx/kb/943076
We are in the process of adding this fix to Microsoft Update so that it will get automatically pushed to users running Excel 2007 or Excel Services 2007. Additionally, the fix will also be contained in the first service pack of Office 2007 when it is released (the release date for SP1 of Office 2007 has not been finalized).
Thank you for your patience,
The Excel TeamPublished Tuesday, October 09, 2007 5:23 PM by David Gainer
- Blogger Play - Now In iGOOGLE
- Blogger Play - Another way of reading blog...
- ClutterMe - Building Website So Easy
- FREE Tracking Incoming Link Using Technorati URL
- Sketchcast - FREE Online Whiteboard
- FREE Stabil, Safe & Fast Web Browser other than IE