- Cool Yule Tools: 2008 Holiday Gift Guide
- 10 kitchen gadgets for the geek gourmet
- Google admits to violating iPhone development terms
- Smartphone smackdown: Storm vs. iPhone
- Google layoffs: 10,000 jobs being cut
If you installed one of those Excel security patches issued by Microsoft earlier this week, you may want to double-check your math.
That's because a bug in the recent MS08-014 patch is causing Excel to return zeroes instead of the correct number when certain types of macros are run within the program.
The issue, which does not affect all Excel users, messes up calculations for Office Excel 2003 users who are grabbing data such as stock quotes or inventory levels from sources in real time and plugging them into an Excel array.
"If you have applications that leverage Real Time Data sources in Visual Basic for Applications functions, we recommend that you perform additional testing before initiating a wide deployment of the update," Microsoft said in an updated frequently asked-questions section of the bulletin on the MS08-014 update.
As a workaround, Microsoft recommends that users run affected Real Time Data functions on individual cells within the spreadsheet, rather than throughout the whole array.
Microsoft warned users of the problem late Thursday, and the company is working on a fix. The company's public relations agency could not immediately say Friday when this update might be released.
Ironically, Office 2003, Service Pack 3 users are not affected by the security flaw that is fixed with this patch, but Microsoft is still pushing this update out to these customers. Microsoft says that this is happening because the update files have higher version numbers than the existing files on Service Pack 3 systems.
Microsoft released four critical security patches on Tuesday, all related to Office. Of these, the MS08-014 update is one of the most important. It fixes a publicly disclosed flaw in Excel that hackers had been exploiting in online attacks since the middle of January.
Partner Content
Brilliantly simple security and control solutions for email, web and endpoint
www.sophos.com
Stopping data leakage
Learn how to exploit your current security investment to control the information that flows into, through and out of your network.
Download the white paper.
Why detection rates aren't enough
Evaluating endpoint security products is a time-consuming and daunting task. Learn the six critical questions you need to ask prospective vendors to get the right endpoint solution.
Download the white paper.
Applications: taking back control
Employees installing unauthorized applications is a growing threat to business security and productivity. Cost-effectively reduce this threat by integrating control into your malware protection.
Learn more today.
Comments (1)
Excel patch causes bad mathBy Anonymous on March 25, 2008, 6:43 pmI'm sorry but the question is begging to be asked, "Has Microsoft done away completely with the QA process"? Vista Excel ... I can see them getting into the search...
Reply | Read entire comment
View all comments