We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
80,259 News Articles

Microsoft patch confuses Excel 2003 calculations

Warning over Patch Tuesday Office update

A bug in Microsoft's MS08-014 patch last week 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.

See also:

Critical Office fixes dominate Patch Tuesday

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 last Thursday, and the company is working on a fix.

Ironically, Office 2003, Service Pack 3 (SP3) 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 SP3 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.

IDG UK Sites

Windows 10 for phones UK release date, price and new features: When will my phone get Windows 10?

IDG UK Sites

It's World Backup Day 2015! Don't wait another minute: back up now

IDG UK Sites

Get the free Adobe Comp CC iPad app for rapid layout design

IDG UK Sites

New 13-inch Retina MacBook Pro (early 2015, 2.7GHz) review: Just about the greatest upgrade any...