We have half a dozen or so users in our department that use an Excel document as a log sheet for keeping track of shipping tracers. The problem we are having is that when one person has the document opened for editing, others cannot edit it at the same time. I tried checking the box that says "Allow changes by more than one user at the same time. This also allows workbook merging. However, when one person has the workbook opened, the others cannot edit it or save their change in Sharepoint.
Is there something I am doing incorrectly with the Excel document that is causing this problem?
Basically, we want more than one user to be able to make changes to the document at one time and to accept all of the changes made to the document by all users that had it open at the same time.
We are using Excel 2007 and MS Sharepoint.
Bookmarks