View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Open a file by multiple users

Yes and no. Take a look at Sharing in the help. At the same time look at all
of the functionallity that is lost when you share out the file. So yes it can
be done but there are a LOT of tradeoffs. I personally never share out files
as I find that it causes as many problems as it solves. When I need
concurrent access to information I use a database.
--
HTH...

Jim Thomlinson


"Scott" wrote:

I put a Excel file on a server for multiple user's updating. There is an
issue that when one user opens the file, the other users cannot update the
same file until s/he exits. Since the user may open it and forget to close
it, other users cannot do any editing. Is there any way to allow multiple
users to edit the central file at the same time?

Thanks,

Scott