News

Excel Patch Causing Calculation Errors

Microsoft admitted on Friday that a patch it released last week is causing Excel 2003 to make some incorrect calculations.

Microsoft admitted on Friday that a patch it released last week is causing Excel 2003 to make some incorrect calculations.

"We have updated bulletin MS08-014 to provide additional information on a newly identified issue that causes Microsoft Excel 2003 calculations to return an incorrect result when a Real Time Data source is used," Microsoft's Security Response Center's Bill Sisk wrote in a blog post last week.

"The issue affects a specific scenario and may not affect you...Our teams are testing a fix and will release it once it meets our quality bar for broad distribution," he continued.

Microsoft offers some insight into the problem in Knowledge Base (KB) article 950340. According to the KB, after the patch is applied on systems with "Microsoft Office Excel 2003 installed, array-entered functions that contain a Visual Basic for Applications (VBA) macro that refers to a Real Time Data source return an incorrect value. The incorrect value is usually 0."

According to the very short KB item, for a current workaround, Microsoft recommends, "Run the function on each cell individually instead of on the array of cells."

The only other information available in the KB is that Microsoft is working on a fix and will post more information as it becomes available.

The patch was released last week to stop versions of Excel from allowing several types of remote execution attacks.

About the Author

Becky Nagel is the vice president of Web & Digital Strategy for 1105's Converge360 Group, where she oversees the front-end Web team and deals with all aspects of digital strategy. She also serves as executive editor of the group's media Web sites, and you'll even find her byline on PureAI.com, the group's newest site for enterprise developers working with AI. She recently gave a talk at a leading technical publishers conference about how changes in Web technology may impact publishers' bottom lines. Follow her on twitter @beckynagel.

Featured

  • Microsoft Browser Support for TLS 1.0 and 1.1 Ending 2H 2020

    Microsoft announced on Tuesday that its plans to drop support for Transport Layer Security (TLS) protocols 1.0 and 1.1 in its browsers will get delayed by a few months until the second half of this year.

  • Attackers Using Excel Read-Only Files To Obscure Malware

    Attackers can attempt to hide malicious payloads in Excel files sent by e-mail by using a standard Excel feature, according to a Tuesday post by Mimecast researchers.

  • Microsoft 365 Personal and Family Product Unveiled

    Microsoft on Monday announced new "Microsoft 365 Personal and Family subscriptions" to come next month, a new single consumer product providing access to applications such as Excel, PowerPoint and Word.

  • Microsoft Shifting Away from Office 365 Brand Name in April

    Microsoft on Monday announced coming product naming changes, where "Office 365" is mostly getting replaced by the "Microsoft 365" brand.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.