Then perhaps use Access for your address database instead.

Jeff_in_SC wrote:

No idea how it got sorted to begin with. Guess I can go to the list of names
and reverse the order to surname, given name so I can get the orginal order
back. Thanks for your help. I'm beginning to hate Excel.

"macropod" wrote:


Hi Jeff,

Excel doesn't store a sorting history in its saved files. Whilst you can undo a sort on a while while its open, once that sort has
been saved and the file closed, there's no going back.

--
Cheers
macropod
[MVP - Microsoft Word]


"Jeff_in_SC" wrote in message ...

I opened up a previous Excel doc and it was inexplicably sorted by the data
in one particular column. I don't want any sorting at all on the document,
yet when I go to Data sort none, it returns an error message saying that
the field cannot be none. How can I take OFF the sorting function on this
document so it appears in the original order it was created in?