Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
one workbook, multiple users....
I plan to create a single workbook which multiple users will
add their data into. It is possible that two or more users might attempt to add data simultaneously, but this might not always occur since only 16 people will have access to the workbook. Most users will probably close the multi-user workbook when they are finished....some users might also keep that workbook open once they are finished saving the file. My question is, are there any pitfalls or facts or valuable information that I should be aware of before I create this multi-user workbook?? For example, do I need to set any special workbook settings in Excel 2007?? etc.. I have never created a workbook that multiple users will share, so I just want to be well informed before I create the workbook. Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
one workbook, multiple users....
Just don't do it. Excel file sharing for a purpose like this just creates
more headaches than it's worth. If it's important to use excel instead of a database to collect data from users, then create a template file, give them each a copy, and have them store the copies in a common location with a consistent naming convention. Then use VBA to automate the collection of the data from their separate files. "Robert Crandal" wrote: I plan to create a single workbook which multiple users will add their data into. It is possible that two or more users might attempt to add data simultaneously, but this might not always occur since only 16 people will have access to the workbook. Most users will probably close the multi-user workbook when they are finished....some users might also keep that workbook open once they are finished saving the file. My question is, are there any pitfalls or facts or valuable information that I should be aware of before I create this multi-user workbook?? For example, do I need to set any special workbook settings in Excel 2007?? etc.. I have never created a workbook that multiple users will share, so I just want to be well informed before I create the workbook. Thank you! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
one workbook, multiple users.... (Share workbook)
Then why does Excel 2007 have a feature called
"Share Workbook"?? What is the purpose of this setting? The help caption for this button reads: "Allows multiple people to work in a workbook at the same time" Would this benefit me in any way?? thank u B Lynn B "B Lynn B" wrote in message ... Just don't do it. Excel file sharing for a purpose like this just creates more headaches than it's worth. If it's important to use excel instead of a database to collect data from users, then create a template file, give them each a copy, and have them store the copies in a common location with a consistent naming convention. Then use VBA to automate the collection of the data from their separate files. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
one workbook, multiple users....
Just because somebody tells you to jump off a cliff doesn't mean that you should do it! You asked for recommendations and we gave you our recommendations. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181351 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passwords for Multiple Users of Workbook | Excel Discussion (Misc queries) | |||
sharing workbook for multiple users | Excel Worksheet Functions | |||
Workbook Refreshes For Multiple Users | Excel Worksheet Functions | |||
Multiple users workbook? | Excel Discussion (Misc queries) | |||
Multiple users in one workbook? | New Users to Excel |