Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One out of 15 computers/users VERY Slow after SP update | Excel Discussion (Misc queries) | |||
Forcing users to update spreadsheets | Excel Discussion (Misc queries) | |||
HOW TO UPDATE 1 WORKSHEET FROM 2 DIFRENT USERS | Excel Worksheet Functions | |||
How to allow multiple users to update workbook (on network)? | Excel Discussion (Misc queries) | |||
Auto-update with multi-users | Excel Worksheet Functions |