Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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
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:
http://update.microsoft.comMicrosoft 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 updatesTo do this, follow these steps:
Method 2: View the currently installed version of ExcelTo do this, follow these steps:
(http://support.microsoft.com/kb/943985/ )MS08-014: Description of the security update for Excel 2003: March 11, 2008