Microsoft KB Archive/135837

= XL7: Shared Documents Questions and Answers =

PSS ID Number: 135837

Article Last Modified on 3/21/2001

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q135837





SUMMARY
This article contains questions and answers about working with shared documents in Microsoft Excel for Windows 95, version 7.0.



MORE INFORMATION
 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. 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</li></ul>

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.</li> 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.</li> 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, see 131552. For more information about other features that are unavailable when you are using a shared list, see 130560.</li></ol>

Keywords: kbinfo KB135837

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

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

© 2003 Microsoft Corporation. All rights reserved.