FastTips: "Shared Documents Questions and Answers" (WE1210)

• Microsoft Excel for Windows 95, version 7.0

This article contains the text of "WE1210: Working with Shared Documents Questions and Answers," which is available on the Microsoft FastTips service for Desktop Applications. To access this service, call (800) 936- 4100.

You can obtain this Application Note from the following sources:

• Microsoft's World Wide Web Site on the Internet
• The Internet (Microsoft anonymous ftp server)
• The Microsoft Network (MSN)
• Microsoft Download Service (MSDL)
• Microsoft FastTips Technical Library
• Microsoft Product Support Services

THE TEXT OF WE1210

  Microsoft(R) Product Support Services Application Note (Text File)
      WE1210: WORKING WITH SHARED DOCUMENTS QUESTIONS AND ANSWERS

                                                   Revision Date: 8/95
                                                      No Disk Included

 INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY
 ACCOMPANY THIS DOCUMENT (collectively referred to as an Application
 Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
 EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR
 PURPOSE. The user assumes the entire risk as to the accuracy and
 the use of this Application Note. This Application Note may be
 copied and distributed subject to the following conditions:  1) All
 text must be copied without modification and all pages must be
 included;  2) If software is included, all files on the disk(s)
 must be copied without modification (the MS-DOS(R)  utility
 diskcopy is appropriate for this purpose);  3) All components of
 this Application Note must be distributed together;  and  4) This
 Application Note may not be distributed for profit.

 Copyright (C) 1995 Microsoft Corporation.  All Rights Reserved.
 Microsoft, MS-DOS, and Windows are registered trademarks of
 Microsoft Corporation.

1. Q. Is there a limit to the number of users that can work on one
      shared list at one time?

   A. No. There is no limit to the number of users that can work on a
      shared list at one time.

2. Q. With the shared list feature, what happens if two users enter
      data into the same cell at the same time?

   A. Microsoft Excel has built-in functionality to handle such a
      conflict if it occurs. The Conflict Resolution dialog box will
      display the following information:

       - The values that were entered simultaneously
       - Where on the sheet these values are located
       - When the values were entered
       - Who entered each value

      This information allows you to choose which value you want to
      use. Microsoft Excel also displays a status log that shows each
      conflict along with its resolution.

3. Q. How are changes updated in a shared list?

   A. When you work with a shared list, changes from other users are
      not added until one of the people using the list clicks the
      Save command.

4. Q. When I use a shared list, the Note command on the Insert menu
      is available. However, when I click Note, and type a note,
      nothing happens. Why can't I insert a cell note in the
      worksheet?

   A. You cannot insert a cell note in a worksheet when you are using
      a shared workbook. For more information about this issue, order
      item number Q131552 from the FastTips Catalog. For information
      about other features that are unavailable when you are using a
      shared list, order item number Q130560 from the FastTips
      Catalog.

TO OBTAIN THIS APPLICATION NOTE

The following file is available for download from the Microsoft Software Library:

 ~ WE1210.EXE (size: 14504 bytes) 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

If you are unable to access the source(s) listed above, you can have this Application Note mailed or faxed to you by calling Microsoft Product Support Services Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7070. If you are outside the United States, contact the Microsoft subsidiary for your area To locate your subsidiary, see the Microsoft World Wide Offices Web site at:

   http://www.microsoft.com/worldwide/default.htm