Select the product you need help with

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

Article ID: 950340

SYMPTOMS

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 | Give Feedback

WORKAROUND

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

Back to the top | Give Feedback

RESOLUTION

To resolve this problem, install the updated version of security update 943985. To do this, visit the following Microsoft Web site:

http://update.microsoft.com

(http://update.microsoft.com)

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 | Give Feedback

STATUS

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

Back to the top | Give Feedback

MORE INFORMATION

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
  1. Click Start
    Collapse this imageExpand this image
    , type Programs in the Start Search box, and then click Programs and Features in the Programs list.
  2. Click View installed updates.
- Windows XP
  1. Click Start, click Run, type appwiz.cpl, and then click OK.
  2. Click to select the Show updates check box.
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.

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
  Collapse this imageExpand this image
  , 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.