XL7: More Data Sorted Than Expected in List in Shared Workbook

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel version 7.0, 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. For more information, please see the following article(s) in the Microsoft Knowledge Base:

         ARTICLE-ID: Q136698
         TITLE     : XL7: Allow Multi-User Editing Property Available to All
                     Users
   
   

2. Sort the list.

3. 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 of Microsoft Excel 7.0.