Gino,
The following restrictions are in place on a shared workbook; at least
in Excel 2002.

You won't be able to add or change the following: merged cells,
conditional formats, data validation, charts, pictures, objects
including drawing objects, hyperlinks, scenarios, outlines, subtotals,
data tables, PivotTable reports, workbook and worksheet protection, and
macros.

This is what is most likely causing the sort to default to the entire
sheet rather than allowing you to sort a limited range.

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=559346