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 serves as vice president of AI for 1105 Media specializing in developing media, events and training for companies around AI and generative AI technology. She also regularly writes and reports on AI news, and is the founding editor of PureAI.com. She's the author of "ChatGPT Prompt 101 Guide for Business Users" and other popular AI resources with a real-world business perspective. She regularly speaks, writes and develops content around AI, generative AI and other business tech. She has a background in Web technology and B2B enterprise technology journalism.

Featured

  • Microsoft Appoints Althoff as New CEO for Commercial Business

    Microsoft CEO and chairman Satya Nadella on Wednesday announced the promotion of Judson Althoff to CEO of the company's commercial business, presenting the move as a response to the dramatic industrywide shifts caused by AI.

  • Broadcom Revamps VMware Partner Program Again

    Broadcom recently announced a significant update regarding its VMware Cloud Service Provider (VCSP) program, coinciding with the release of VMware Cloud Foundation (VCF) 9.0, a key component in Broadcom’s private cloud strategy.

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.