Shared workbook and moving\saving conflicts

[Jonny Two Shoes]

Hi there,

Quick one here hopefully, I don't know if this has been asked here. Does anyone know how I can share an excel workbook in such a way that if multiple users on the workbook make changes it does not ask which changes to keep or overwrite anything, instead it simply moves all changes made by one user to the next row so that nothing is lost and no notice messages show?. For instance if I work on a customer contact details list at the same time as someone else and we are both entering seperate details on the same row then depending on who saves first it will simply move the other users info to the next line and nothing is lost.

We are using Excel 2000 however I am sure this feature is supported I just don't know how to get it back and there are plenty of articles on tracking changes and sharing workbooks but they don't explain how to do what I am trying to do.

thanks

[Jonny Two Shoes]

I take it this is a stupid question then? Lol even in another forum I have no reply

[Jonny Two Shoes]

At least someone tell me this is not possible, goodness sakes!!

The whole story started when I fiddled around with sharing and security permissions for some folders as we are being audited and need to ensure everything is secure.

Now I am being blamed for taking away that feature on a specific excel workbook under one of the folders. I have since given the correct users full access to the folder and subfolders/files within which the excel file resides.

The users tell me that it was set up so that when two or more users enter info in the same cell and save it would simply show both their entered info once they closed and opened the files again without prompting who's changes to keep or overwriting anything. As though it simply moved the conflicting changes to the next row or created a new row for it. I am still having no luck getting it back the way it was and of course we all know the look of frustrated users don't we.