Microsoft KB Archive/58245

= XL: Defined Names Not Sorted in Excel =

Article ID: 58245

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q58245





SUMMARY
Named ranges that are included within a Sort area do not change when the area is sorted. The defined names still refer to their original references.



MORE INFORMATION
Defined names refer to a cell reference and not to the cell contents specifically. When performing a Data Sort, you are only sorting the contents of the cells. Because of this, a defined name may not be referencing the same data after a sort.

Additional query words: xl97 xl98 xl2000 xl2001 xl2002

Keywords: kbinfo KB58245

-

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

© Microsoft Corporation. All rights reserved.