<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d3335479955331420036\x26blogName\x3dWebworm+GenTech\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://webworm-gentech.blogspot.com/search\x26blogLocale\x3den_US\x26v\x3d2\x26homepageUrl\x3dhttp://webworm-gentech.blogspot.com/\x26vt\x3d7736631995446592428', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Enter your email address:




Webworm GenTech

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.

"Any combination of numbers e.g. 77.1*850, 65534+1, etc that should calculate to 65535 will show 100000 in Excel 2007."...See above image.

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.


Calculation Issue Update (Fix Available)

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:

Excel 2007: office-kb943075-fullfile-x86-glb.exe
64-bit Excel Services 2007: office-kb943076-fullfile-x64-glb.exe
32-bit Excel Services 2007: office-kb943076-fullfile-x86-glb.exe

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 Team

Published Tuesday, October 09, 2007 5:23 PM by David Gainer


Related Topics

Labels: ,

posted by Webworm INTech, 7:20 PM


Add a comment