I have a workbook, that several people access simultaneously on a network.
When they try to save it other people lose their work as it only takes on the
lastest changes, is there anyway to say all changes by all users at once?

One of the experts might have a better response but as far as I know you
can't get around this as each person loads a version on their computer and
when they save back that will become the new version. The working
simultaneously part is the problem, when i have several users that use the
same sheet I set it so that only the 1st user that opens the file can make
changes, all other people will get only read only access until that 1st
person is finished. This works well except that you must make sure that the
users save and get out of the spreadsheet as soon as they are done. (As in
no leaving the sheet open for a couple hours as they go to lunch.)

"Jo Davis" wrote:

I have a workbook, that several people access simultaneously on a network.
When they try to save it other people lose their work as it only takes on the
lastest changes, is there anyway to say all changes by all users at once?

Thanks Tim, i have treid to get people to work like this with no luck! I
think what they need is a database not excel!

"tim m" wrote:

One of the experts might have a better response but as far as I know you
can't get around this as each person loads a version on their computer and
when they save back that will become the new version. The working
simultaneously part is the problem, when i have several users that use the
same sheet I set it so that only the 1st user that opens the file can make
changes, all other people will get only read only access until that 1st
person is finished. This works well except that you must make sure that the
users save and get out of the spreadsheet as soon as they are done. (As in
no leaving the sheet open for a couple hours as they go to lunch.)

"Jo Davis" wrote:

I have a workbook, that several people access simultaneously on a network.
When they try to save it other people lose their work as it only takes on the
lastest changes, is there anyway to say all changes by all users at once?