XL: Defined Names Not Sorted in Excel

• Microsoft Excel 98 Macintosh Edition
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
• Microsoft Excel for the Macintosh, versions 4.0, 5.0
• Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0
• Microsoft Excel 97 for Windows

SUMMARY

Named ranges that are included within a Sort area do not change when the area is sorted. The defined names are still referring 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.

REFERENCES

"Microsoft Excel Guide," version 3.0, page 232

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0

Keywords : xlui
Version : MACINTOSH:4.0,5.0,98; WINDOWS:2.x,3.0,4.0,4.0a,5.0,7.0,97
Platform : MACINTOSH WINDOWS
Issue type : kbinfo