Editing of Excel Document by multiuser

[Louicide]

Hi,

I have an Excel document shared by Multiple users.
They each need to Edit some part of the document.
They all can open the Document and edit at the same time but Only the 1st user can save his/her changes.

Is there a way that I can notify the other user whenever the document is opened by the 1st user so that the others will know that the file is already in use?

Thanks

 

[Louicide]

Forget to mention that the document are being shared on the intranet using Sharepoint 2003

 

[xlbo]

AFAIK, Sharepoint has its own "check in / check out" scheme which doesn't allow multi user editing. This is because all the files are actually stored on a different server (not the one where the original file was created and saved)

To edit a file, you have to take a copy of the server copy (check out), make any changes to it, save it locally and then load it back to the server (check in)

There may be new functionality in the latest release of Sharepoint but with the current version, to have multi user editing, you must keep the file on a shared netwrok drive rather than in sharepoint

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[Louicide]

Hi xlbo,

Thanks very much.

I've already tried the Check out/Check in option.
But it's a bit complicated for the end users (Operational Staff) since they are not very much computer literate.

I thought there is another easier way.

Thanks again

 

[ricpinto]

Maybe what you need is to understand how the workbook is shared . .

http://www.jmu.edu/computing/ittrai...Excel Sharing Workbooks and Tracking Changes'