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.