update in the workbook by different users

[sanju]

I have a worksheet shared by 6 people at sharespace.
Please let me know how can I control the parallel updates of all in
the sheet.

e.g Let us say all users open up file at same time t. If user 1 make
some change and save it at time t+1.
Then if user 2 is saving it at t+2, updates entered by user 1 will be
missed out.

Please advise how can I manage this using macro or sharing control.

regards
sanjay

 

[sanju]

Don't use a shared workbook, you will always loose some of the data.
Excel isn't design to handle conflicts that occur when multiple peole
read and write data.

Instead of using a shared workbook store your data use an access
database.  You can read and write to the Access database from a macro
inside Excel VBA.  Use Excel as a front-end program where the user
enters and retrieves data and make the Access Database the shared item.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=186244

Excel Live Chat

Thanks Joel, Please can you elaborate on this. This all looks very
difficult.
Do you have any idea about Windows sharepoint.