The information in this article applies to:
SYMPTOMSWhen you save a worksheet in Microsoft Excel 98 Macintosh Edition, you may receive an error message similar to the following: You receive this error message even though the worksheet does not contain any functions that are not available in this file format. When you reopen the file, the formula in the indicated cell is gone. Only the value returned by the formula remains in the cell. CAUSE
This problem may occur when the following conditions are true:
-and- WORKAROUND
To work around this problem, use either of the following methods:
-or- Q165260 XL97: COUNTA Function Changed to COUNT STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATIONYou can use the COUNT function to count the number of numbers in a range of cells. The COUNTA function allows you to count the number of nonblank cells in a range of cells. For example, if you have the following data
the formula =COUNT(A1:A5) returns the value 2. This is true because there
are two numbers in the range of cells. The formula =COUNTA(A1:A5) returns
the value 4 because there are four nonblank cells in the range.
The COUNT and COUNTA functions are supported by all versions of Lotus 1-2-3, so you should not receive an error message when you save a worksheet that contains the COUNT function in the WK1 format. Additional query words: XL98 .WK1 .WK3 .WK4
Keywords : xlloadsave xlformula xl123Quattro |
Last Reviewed: January 12, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |