update in the workbook by different users
 

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

update in the workbook by different users
 

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

update in the workbook by different users
 

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.

update in the workbook by different users
 

The operating system like windows share Point cannot resolve conflicts
when two people simulataneously writes to a file like a database. the
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 database
must track each users entries and must either not allow Person 2 to read
the entry while Person 1 is changing the entry or not allow Person 1 to
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 be
lockout so nobody can read the file until the server is rebooted. Often
people have to make a copy of the lockout workbook so then can continue
to make changes to the workbook.


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

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


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

http://www.thecodecage.com/forumz/chat.php