The information in this article applies to:
SYMPTOMSWhen you copy and paste cells on your worksheet, formulas that refer to data in the range you copied return a "#NAME?" error. CAUSE
This problem occurs when you do the following:
-and- WORKAROUND
To work around this problem, reenter the formula. To reenter a formula,
follow these steps:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
Microsoft Excel 97 introduces natural language formulas, which is a method
you can use to refer to a cell range in a table by using row or column
labels as the reference name. Natural language formulas use the
intersection feature that is available in earlier versions of Microsoft
Excel.
Q161881 XL97: How to Use Natural Language Formulas Additional query words: XL97 nlf
Keywords : kberrmsg xlformula |
Last Reviewed: October 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |