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 translations Article translations
Article ID: 950340
Expand all | Collapse all

On This Page

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.

WORKAROUND

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

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
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.

STATUS

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

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:
  1. 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
         Start button
        , 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.
  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.

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
      Collapse this imageExpand this image
       Start button
      , 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:
943985 MS08-014: Description of the security update for Excel 2003: March 11, 2008

Properties

Article ID: 950340 - Last Review: September 30, 2011 - Revision: 4.0
Keywords: 
kbexpertisebeginner kbqfe kbsecurity kbsecvulnerability kbbug kbfix KB950340

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com