Sharing Excel Workbook with Multiple Users
- Thread starter Fadil
- Start date
bobhc
Excel Ninja
It will turn your work book in to a complete mess, Excel was never designed for multi users, if they are all entering data at the same time how are you updating the work book.
One user enters data that will change the data contents for users, but others do not know this as their work book has not up dated.
Some will be working with one set of out of date (by a few minutes) and others will be undoing the work of others by entering data that will undo or corrupt entered data.
Use SharePoint and Access to gather the information and if needs must export to Excel.
.
One user enters data that will change the data contents for users, but others do not know this as their work book has not up dated.
Some will be working with one set of out of date (by a few minutes) and others will be undoing the work of others by entering data that will undo or corrupt entered data.
Use SharePoint and Access to gather the information and if needs must export to Excel.
.
Yes to both questions. Can be done from the Review Tab, Share Workbook button.
This lets multiple users have the workbook open and make changes. Note that you can't delete worksheets or edit macros while shared.
IMO, however, shared workbooks tend to get overly complicated and often crash, as the file system does not properly keep track of when users are done and have exited out, so I'd tried to avoid it if possible.
This lets multiple users have the workbook open and make changes. Note that you can't delete worksheets or edit macros while shared.
IMO, however, shared workbooks tend to get overly complicated and often crash, as the file system does not properly keep track of when users are done and have exited out, so I'd tried to avoid it if possible.
Thank you all for your response.
My use of shared excel workbook was going to be to log in complaints by three different parties in three different columns and have it tracked there since MS Access is not an option in this case since it is not installed on all machines since it requires extra license
For example a call center will log in a complaint for an issue, the helpdesk will log in complaint for another issue and the main office will log in another complaint for another issue, in three different columns within the same workbook/sheet. Will this cause any complications?
Regards,
Fadil
My use of shared excel workbook was going to be to log in complaints by three different parties in three different columns and have it tracked there since MS Access is not an option in this case since it is not installed on all machines since it requires extra license
For example a call center will log in a complaint for an issue, the helpdesk will log in complaint for another issue and the main office will log in another complaint for another issue, in three different columns within the same workbook/sheet. Will this cause any complications?
Regards,
Fadil
bobhc
Excel Ninja
The last post makes your first post a lot clearer. It is the simultaneously that gives Excel the need of an aspirin.
The way you describe it probably would not give you major problems, the main problem is not with Excel but the users, who for reasons only known to them selves think they know better than you.