Fix for issue in Excel 2007 involving calculation of numbers around 65,535


You may have recently read of an issue in Excel 2007 involving calculation of numbers around 65,535 where Excel 2007 would return a value of 100,000 instead of 65,535. Excel incorrectly displays the result of a calculation in 12 very specific cases. 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.


 


You can get more detail on the problem here:


 


Microsoft Excel : Calculation Issue Update


http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx


 


We take calculation in Excel very seriously and have just released an update for both Excel 2007 and Excel Services in Office SharePoint Server 2007 that fixes this problem.


 


Description of the Excel 2007 hotfix package: October 9, 2007


http://support.microsoft.com/default.aspx?scid=kb;en-us;943075


 


Description of the Excel Services in Office SharePoint Server 2007 hotfix package: October 9, 2007


http://support.microsoft.com/default.aspx?scid=kb;en-us;943076


 


For all the latest information on Excel and Excel Services make sure you regularly visit the Excel team blog:


 


Microsoft Excel Team Blog


http://blogs.msdn.com/excel