Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can 7 workers input Excel data into a Master Sheet?
I've read about Sharing, but what I really need is for several workers to use
a copy of my Master SS and input their own data, and have it automatically go to my Master without conflicts about cell data duplication. Can Excel or Access automatically adjust for multiple users inputting data at once? Thanks in advance, and please forgive if the answer is plain and in front of me and I just do not see it :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can 7 workers input Excel data into a Master Sheet?
Sure multiple users can access an Excel file at athe same time and input data.
Tools / share work book / select changes by more than one user / "Zillafan" wrote: I've read about Sharing, but what I really need is for several workers to use a copy of my Master SS and input their own data, and have it automatically go to my Master without conflicts about cell data duplication. Can Excel or Access automatically adjust for multiple users inputting data at once? Thanks in advance, and please forgive if the answer is plain and in front of me and I just do not see it :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can 7 workers input Excel data into a Master Sheet?
In EXCEL 2007 the commands a-
Review Changes group Share Workbook Editing tab Place a green tick in the box marked:- Allow changes by more than one user at the same time. This also allows workbook merging. OK. If I were going to deploy this functionality I would test it very carefully before deployment paying particular attention to what happens when one or more users try to update the same field at the same time. If my comments have helped please hit Yes. Thanks. "Zillafan" wrote: I've read about Sharing, but what I really need is for several workers to use a copy of my Master SS and input their own data, and have it automatically go to my Master without conflicts about cell data duplication. Can Excel or Access automatically adjust for multiple users inputting data at once? Thanks in advance, and please forgive if the answer is plain and in front of me and I just do not see it :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master sheet data HELP!(please) | Excel Worksheet Functions | |||
Showing Specific Data from Master Sheet to Another Sheet | New Users to Excel | |||
how do i transfer necessary rows/data from a master excel sheet | Excel Worksheet Functions | |||
Moving data in one excel column to another sheet based on user input | Excel Discussion (Misc queries) | |||
Protecting excel sheet for data input | Excel Discussion (Misc queries) |