XL2000: Quattro Pro Defined Names in Microsoft Excel Formulas (214000)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbhowto KB214000 |
|---|
|