Top Tech News

CIO Today Network Sites:   Top Tech News  |   CIO Today   |   Mobile Tech Today   |   Data Storage Today
News & Product Reviews for Tech Leaders
Thursday, September 9th 
Home
Network Security
Microsoft/Windows
Linux/Open Source
Apple/Macintosh
Wireless Tech
World Wide Web
Tech Trends
Data Storage
Software
Hardware
Communications
Spam & Hackers
Chips & Processors
Cloud & Virtualization
Personal Tech
 
Free Newsletters
Top CIO News
 
Mobile Tech Today
 

Advertisement
Microsoft/Windows

Microsoft Fixes Excel Calculation Bug

Microsoft Fixes Excel Calculation Bug
October 12, 2007 8:17AM

Bookmark and Share
A calculation bug that crept into Excel 2007 has officially been eliminated this week with Microsoft making a patch available for download. Those not concerned about fixing the Excel calculation issue right away can wait for the patch to be available through Microsoft's update service or through Office 2007's first service pack.


Microsoft has fixed an embarrassing error in Excel 2007 -- a major component of the Office 2007 productivity Relevant Products/Services suite. The issue involves miscalculating numbers around 65,535.

The first reported problem revolved around "77.1 x 850," according to Microsoft. But the Excel team's testing, along with additional reports from outsiders, soon revealed this was not the only instance where Excel 2007 would return a value of 100,000 instead of 65,535.

"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," the officials wrote on an Excel developer team blog.

Excel users can download the fix manually or wait until it is released as part of the first service pack for Office 2007. Microsoft has not yet offered a release date for Office 2007 Service Pack 1.

Root of the Problem

Microsoft traced the root of the problem to changes that were made to the Excel calculation logic for the latest version of the software. Excel incorrectly displays the result of a calculation in 12 specific cases.

However, the issue actually is not in the calculation itself. In other words, calculation stored in Excel's memory is correct. The problem is only in the result that is shown in the sheet. The equation "850 x 77.1" will display an incorrect value, but if you then multiply the result by two, you will get the correct answer, Microsoft said.

Of the 9.214*10^18 different floating point numbers that Excel 2007 can store, there are six floating point numbers between 65534.99999999995 and 65535, and six between 65535.99999999995 and 65536 that cause this problem, according to Microsoft.

Consumers can't actually enter these numbers into Excel directly because Excel will round to 15 digits on entry. However, any calculation returning one of those results will have this issue if the results of the calculation are displayed in a cell. No other calculation results are affected.

Sending Pest Control

In other Microsoft news, the company issued a security advisory on Wednesday concerning a URL handling vulnerability in Windows XP and Windows Server 2003 with Internet Explorer 7, which could allow remote code execution. Microsoft said it is investigating public reports of the vulnerability.

"We are not aware of attacks that try to use the reported vulnerability or of customer Relevant Products/Services impact at this time. Microsoft is investigating the public reports," the company said in its security blog. The vulnerability does not affect Windows Vista or any supported editions of Windows where Internet Explorer 7 is not installed.

Microsoft said that upon completion of its investigation, it would take the "appropriate action" to protect its customers, which may include providing a solution through a service pack, our monthly security update release process, or even an out-of-cycle security update.

Tell Us What You Think
Comment:

Name:

Advertisement



 Microsoft/Windows
1. Device Makers Get Windows Phone 7
2. Fix Your Internet Explorer Annoyances
3. Document Leaks Details About IE9
4. Microsoft Will Offer Faster IE9 Beta
5. Patch Fixes SMB Danger from Within


advertisement


 Most Popular Articles
1. Droid X Users Cautioned About Unofficial Android Update
2. Google Aims at Twitter with Organized Real-Time Search
3. Samsung Unleashes Its Galaxy Tab on Apple's iPad
4. Security Threats Reach Record Levels, IBM Reports
5. Gmail Users Dial One Million VoIP Calls in 24 Hours

Have an informed opinion on this story?
Send a Letter to the Editor.
We want to know what you think.
Send us your Feedback.

 Related Topics  Latest News & Special Reports

  RIM Snaps Up 'Documents To Go'
  IDC: Android To Hit Number 2 In 2014
  Symantec Unwraps Norton 2011 Suite
  Business Use of iPad Boosts Sales
  iPhone 'AntennaGate' Impacted Sales

 Technology Marketplace
Chips & Processors
Is your organization overdue for a desktop or laptop refresh?
Upgrade your computers with HP and Intel
 
Compliance
Manage limitless content today—read EMC’s 15-minute guide to ECM.
 
Data Storage
Isilon scale-out storage is simple. Simple is smart.
 
Digital Life
IT PROS: Receive $10 in rewards to complete a 15 min. survey.
 
Enterprise Hardware
Is your organization overdue for a desktop or laptop refresh?
Upgrade your computers with HP and Intel
 
Enterprise I.T.
IT PROS: Receive $10 in rewards to complete a 15 min survey.
 
Enterprise Software
Manage limitless content today—read EMC’s 15-minute guide to ECM.
 
Mobile Gadgets
White Paper The Motorola ES400: Desktop power in a pocket-sized device
 
Mobile Industry News
The Motorola ES400: Desktop power in a pocket-sized device.
 
Mobile Phones
The Motorola ES400: Desktop power in a pocket-sized device.
 
Navigation
Top Tech News
Home/Top News | Network Security | Microsoft/Windows | Linux/Open Source | Apple/Macintosh | Wireless Tech | World Wide Web
Tech Trends | Data Storage | Software | Hardware | Communications | Spam & Hackers | Chips & Processors
Cloud & Virtualization | Personal Tech
Also visit these Enterprise Technology Sites
Top Tech News | CIO Today | Mobile Tech Today | Data Storage Today

Services:
FreeNewsFeed | Free Newsletters | Free Whitepapers | XML/RSS Feed

About CIO Today Network | How To Contact Us | Article Reprints | Services for PR Pros (In partnership with NewsFactor) | Top Tech Wire | How To Advertise

Privacy Policy | Terms of Service
© Copyright 2000-2010 Top Tech News. All rights reserved. Article rating technology by Blogowogo. Member of Accuserve Ad Network.