Saving a shared worksheet

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

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
 
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
|
|
 
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
Click to expand...

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