Saving a shared worksheet

[Ramesh]

HI,

When a worksheet is setup as shared on the network, and two users have
opened this file concurrently, and both are editing the file, who s version
will get finally saved? Will the data saved by the user who closes first be
lost when the second user saves?

Could you someone enlighten on what really a shared workbook means?

Thanks
Ramesh

 

[Jim Rech]

The whole point of shared workbooks is to save the changes of all
simultaneous users. When two user edit the same cell a 'Resolve Conflicts'
dialog will appear. You should search in Excel help on 'shared workbook'
for more on workbook sharing.

--
Jim
| HI,
|
| When a worksheet is setup as shared on the network, and two users have
| opened this file concurrently, and both are editing the file, who s
version
| will get finally saved? Will the data saved by the user who closes first
be
| lost when the second user saves?
|
| Could you someone enlighten on what really a shared workbook means?
|
| Thanks
| Ramesh
|
|

 

[aidan.heritage]

HI,

When a worksheet is setup as shared on the network, and two users have
opened this file concurrently, and both are editing the file, who s version
will get finally saved? Will the data saved by the user who closes first be
lost when the second user saves?

Could you someone enlighten on what really a shared workbook means?

Thanks
Ramesh

A shared workbook means a disaster waiting to happen - shared
workbooks should be avoided at all costs.