More data sorted than expected in list in shared workbook in Excel
Article ID: 136093
Article Last Modified on 7/25/2007
APPLIES TO
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
This article was previously published under Q136093
SYMPTOMS
In Microsoft Office Excel, when you attempt to sort a list in a shared
workbook, entire rows or columns of data are selected and sorted; that is,
the selection that is sorted is not limited to the range that contains the
list.
CAUSE
In shared workbooks, data is sorted by whole rows or whole columns.
WORKAROUND
To work around this problem, use the following steps to sort the list:
- Unshare the workbook. To do this, click Shared Lists on the File menu,
select the Editing tab, and clear the Allow Multi-User Editing check
box.
CAUTION: If you unshare the workbook while other users are working on
it, their changes may be lost.
- Sort the list.
- To reshare the workbook, click Shared Lists on the File menu, select the
Editing tab, and select the Allow Multi-User Editing check box.
STATUS
This behavior is by design.
Keywords: KB136093