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