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

Last reviewed: October 6, 1997
Article ID: Q135837
The information in this article applies to:
  • 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

For complete information, see the "To Obtain This Application Note" section at the end of this article.

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

The following information applies to Microsoft Excel for Windows(R) 95, version 7.0.

 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) 

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

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

You can also have this Application Note mailed or faxed to you from the automated Microsoft FastTips Technical Library, which you can call 24 hours a day, 7 days a week at (800) 936-4100. NOTE: The FastTips Technical Library is available only to customers within the U.S. and Canada.

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


Additional query words: 7.00
Keywords : xlwin kbfasttip kbfile
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 6, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.