update in the workbook by different users

S

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
 
J

joel

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.
 
S

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
Click to expand...

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

joel

The operating system like windows share Point cannot resolve conflict
when two people simulataneously writes to a file like a database. th
database must resolve a conflict.

suppose you have this situation

A) Person 1 reads a database entry
B) Person 2 reads the same entry
c) Person 2 writes the entry back into the database
d) Person 1 writes the entry back into the database

Under this situation the Person 2 data get over-written. The databas
must track each users entries and must either not allow Person 2 to rea
the entry while Person 1 is changing the entry or not allow Person 1 t
write the entry.


Excel doesn't perform the checking on each entry in the spreadsheet.
Instead excel tries to lock out the spreadsheet to resolve conflicts.
Excel algorithm often don't work and causes the spreadsheet to b
lockout so nobody can read the file until the server is rebooted. Ofte
people have to make a copy of the lockout workbook so then can continu
to make changes to the workbook.


You don't have this problem if you use an access database instead of a
excel spreadsheet.

I don't know you programming talents so I can't say how difficult thi
would be. I have so examples of reading and writing to an acces
database using Excel VBA.
 
Top