Make sure that there's an empty column between the range to be sorted and any
"adjacent" data.

If you have a locked cell butting up to the range to be sorted, excel yells!



Pete Walburn wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

--

Dave Peterson