A non fixed Microsoft Excel 2007 has calculation issues with certain numbers. Two scenarios exist that result in a false value being shown as the result of a calculation. If the result of a calculation is a number between 65534.99999999995 to 65535 the result will be shown as 100000 instead.
The second scenario is that the result of a calculation is a number between 65535.99999999995 to 65536 which will display the result as 100001 instead. While it is not very likely that many users will encounter the issue, considering that most calculations made in the program won't result in a matching number, it is nevertheless a issue that needed to be resolved by the company.
You can try it for yourself if you do a calculation of 77.1 x 850 for instance. Use the build in Windows calculator for instance to calculate the numbers and afterwards Microsoft Excel 2007.
You will see the difference immediately. Please note that only Excel 2007 is affected. Microsoft admitted that this was a display error and that Excel 2007 would use the correct figure. Microsoft released a 34 Megabyte hotfix for Excel 2007 which corrects this problem.
To apply the hotfix simply download it from the linked Microsoft Support page above and execute it on your system afterwards. Note that Excel should not be open when you do so to avoid any issues installing the patch. A restart of the system is not necessary, and the correct calculations are made once the patch has been installed on the system.
Note that you only need to install the hotfix if you are running Microsoft Excel 2007. Also note that the Microsoft Office Suite Service Pack 1 for Office 2007 includes the patch so that you do not need to download and install it separately if you are already running an updated version of Office.Advertisement
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.