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

ID: Q136093

7.00 WINDOWS kbusage kbprb

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.

KBCategory: kbusage kbprb KBSubcategory: xlwin

Additional reference words: 7.00

Keywords          : xlwin 
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: April 23, 1998