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.

Back to the top

To work around this problem, run the function on each cell individually instead of on the array of cells.

Back to the top

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.

Back to the top

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

To determine the version of the update that you have installed, use either of the following methods.

Back to the top

Method 1: View the list of currently installed programs and updates

To do this, follow these steps:

1.

Use one of the following procedures, depending on the operating system that you are running: • Windows Vista a. Click Start, type Programs in the Start Search box, and then click Programs and Features in the Programs list. b. Click View installed updates. • Windows XP a. Click Start, click Run, type appwiz.cpl, and then click OK. b. Click to select the Show updates check box.

2.

In the list of updates, locate security update 943985. • If a description is listed that resembles the following description, the current update is installed: Security Update for Excel 2003 (KB943985) V2: EXCEL No 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. Notice that "V2" is listed in the description for only the current update.

Back to the top

Method 2: View the currently installed version of Excel

To do this, follow these steps:

1.	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.
2.	Right-click the Excel.exe file, and then click Properties.
3.	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:

Back to the top