Microsoft KB Archive/136093

= 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:
 * 1) 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.
 * 1) Sort the list.
 * 2) 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.