Knowledge Base

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

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.

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.

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.

Keywords: kbinfo KB135837
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch