one workbook, multiple users....

[Robert Crandal]

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!

 

[B Lynn B]

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]

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

 

[joel]

Just because somebody tells you to jump off a cliff doesn't mean tha
you should do it! You asked for recommendations and we gave you ou
recommendations.