The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, when you open a workbook (the "dependent" workbook) that contains formulas that link to cells in another workbook (the "source" workbook), the formulas return a maximum of 255 characters, even though the cells in the source workbook contain more than 255 characters. CAUSEThis problem occurs when the following conditions are true:
-and- RESOLUTIONTo resolve this problem, open the source workbook either before or after you open the dependent workbook. When you do this, the formulas in the dependent workbook return the correct number of characters. 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 INFORMATIONIn Microsoft Excel 98 Macintosh Edition, worksheet cells may contain a maximum of 32,767 characters. This is different from earlier versions of Microsoft Excel in which worksheet cells may contain a maximum of 255 characters. Even though cells may contain a very large number of characters, you may experience problems when you work with these cells. ExampleIn the following example, the formulas in the dependent workbook return a maximum of 255 characters. To see this example, follow these steps:
Additional query words: XL98
Keywords : kbdta xlformula |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |