cell names sorting with data (2003/2007)

We have a spreadsheet with lots of named cells - we tried sorting a selected range by date and found that the cell names did not move with the data. If we dragged to a new position they did. Is there any way to make this work?

Re: cell names sorting with data (2003/2007)

Some options:
If the formulas being sorted are the issue, make the references absolute. and they will still refer to the same cells

If the issue is that the items being sorted are referenced by other cells elsewhere in the workbook, you can, instead of refering to particular cells (whose contents will change on sorting) use some kind of lookup (vlookup, index/match or even an offset) to refer to the item of interest. Essentially make the formulas work regardless of the sorting.