Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a file by multiple users
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a file by multiple users
Just to add to Jim's warning...
Lots of very smart people around here recommend that you stay away from shared workbooks. Workbook corruption is a common complaint with those shared workbooks. If you do use it, remember to make backups. Jim Thomlinson wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a file by multiple users
"Jim Thomlinson" 在郵件
ä¸*撰寫... 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 Jim & Dave, Thanks for your kind warning. However, this is not the solution to say to my colleagues that pls stay away to update the file by multiple users. They do need to do it due to business need. Most of business people hates or scare the use of database due to little knowledge of it. Any other workable solution apart from database available? Regards, Scott |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a file by multiple users
Try the sharing option that Jim mentioned.
Scott wrote: "Jim Thomlinson" 在郵件 ä¸*撰寫... 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 Jim & Dave, Thanks for your kind warning. However, this is not the solution to say to my colleagues that pls stay away to update the file by multiple users. They do need to do it due to business need. Most of business people hates or scare the use of database due to little knowledge of it. Any other workable solution apart from database available? Regards, Scott -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
Multiple copies of Excel file open - :1, :2 | Excel Discussion (Misc queries) | |||
2 users open same file and both can edit/change the file | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
Multiple excel users can open the same file and edit at the same . | Excel Discussion (Misc queries) |