Microsoft KB Archive/214000

= XL2000: Quattro Pro Defined Names in Microsoft Excel Formulas =

Article ID: 214000

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214000





SUMMARY
In Microsoft Excel, you can use range names created in Quattro Pro. However, any formula referring to a defined name will not show the defined name in the formula bar; only the reference will be displayed. To update the formula to refer to a defined name, on the Insert menu, click Name, and then click Apply.



MORE INFORMATION
The user-defined range names exist in the file but are not applied to formulas. Applying the name to the formula does not affect the calculation of the formula. Although this behavior may be confusing, it does not affect the performance of the spreadsheet in Microsoft Excel. The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: xl5 qpro wq1 wb1 XL2000

Keywords: kbhowto KB214000

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.