View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default 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!