On Mar 10, 8:55*pm, joel wrote:
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/sh...d.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.