The information in this article applies to:
SYMPTOMSWhen you open a file in Microsoft Excel 97, worksheet formulas that contain the COUNTA function may be changed so that they use the COUNT function instead. Also, depending on your data, the value returned by the formula that uses the COUNT function may be changed. CAUSE
This problem occurs when the following conditions are true:
-and- -and- RESOLUTION
To resolve this problem, use the following steps:
NOTE: Lotus 1-2-3 does not support the COUNTA function. Also, when you open a .wk1 or .wks file in Microsoft Excel, the COUNT function is not automatically converted to the COUNTA function. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONFor additional information, please see the following article in the Microsoft Knowledge Base: Q158540 XL97: Results Unchanged Toggling Transition Formula Evaluation REFERENCESFor more information about the Count function, click the Index tab in Microsoft Excel Help, type the following text countaand then double-click the selected text to go to the "COUNTA" topic. Additional query words: XL97
Keywords : xlloadsave xlformula xl123Quattro |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |