After you install security update 943985, Excel 2003 calculations return an incorrect result when a Real Time Data source is used in a user-defined Visual Basic for Applications function
This article has been archived. It is offered "as is" and will no longer be updated.
You install security update 943985 on a computer that has Microsoft Office Excel 2003 installed. After you do this, 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.
To work around this problem, run the function on each cell individually instead of on the array of cells.
To resolve this problem, install the updated version of security update 943985. To do this, visit the following Microsoft Web site:
Microsoft has completed research about this issue and has re-released security update 943985 for users of Microsoft Office Excel 2003 Service Pack 2 and of Microsoft Office Excel 2003 Service Pack 3.
Automatic Updates will correctly offer this update to these users regardless of whether the users have applied the original version of security update 943985.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To determine the version of the update that you have installed, use either of the following methods.
Method 1: View the list of currently installed programs and updates
To do this, follow these steps:
Use one of the following procedures, depending on the operating system that you are running: Windows Vista Click Start , type Programs in the Start Search box, and then click Programs and Features in the Programs list. Click View installed updates. Windows XP Click Start, click Run, type appwiz.cpl, and then click OK. Click to select the Show updates check box. In the list of updates, locate security update 943985. Notice that "V2" is listed in the description for only the current update. If a description is listed that resembles the following description, the current update is installed:
Security Update for Excel 2003 (KB943985) V2: EXCELNo additional action is required.
If a description is listed that resembles the following description, the outdated update is installed:
Security Update for Excel 2003 (KB943985): EXCEL You should install the updated version of security update 943985.
Method 2: View the currently installed version of Excel
To do this, follow these steps:
Use one of the following procedures, depending on the operating system that you are running: In Windows Vista, click Start , type %programfiles%\Microsoft Office\OFFICE11 in the Start Search box, and then click OFFICE11 in the Programs list. In Windows XP, click Start, click Run, type %programfiles%\Microsoft Office\OFFICE11, and then click OK. Right-click the Excel.exe file, and then click Properties. Click the Version tab. If the following file version or a later file version is listed, the current update is installed:
11.0.8211.0 No additional action is required.
If the following file version is listed, the outdated update is installed:
11.0.8206.0 You should install the updated version of security update 943985.
For more information about security update 943985, click the following article number to view the article in the Microsoft Knowledge Base:
MS08-014: Description of the security update for Excel 2003: March 11, 2008
Article ID: 950340 - Last Review: 01/16/2015 02:49:33 - Revision: 5.0
Keywords: kbnosurvey kbarchive kbexpertisebeginner kbqfe kbsecurity kbsecvulnerability kbbug kbfix KB950340