View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Spreadsheet usage

You could set the workbook to shared, but I wouldn't recommend it. the best
solution would be to setup the database in access and then export it to excel
for other people to see the results. Access is designed for sharing while
excel isn't.

If more than one person is updating the database make a 2nd copy of hte
workbook. then after all the datta is entered just combine the 2 workbooks
into one workbook by copying the sections from one workbook to the 2nd
workbook.

" wrote:

Is it posible to have two or more people entering data into the same
spreadsheet at the same time? What I have is score sheet which when
there is over 160 players it takes a long time to enter all scores.
More people entering the data will take less time. Also I asked if
there was a way of having a spread sheet automaticaly fill any size
screen to a predetermined configuration, although this was not
answered in this forum I now have the code to do it, Thanks.