shared workbook, saving work my multiple users

[obeo2k2]

hi guys,

need a bit of help with a shared spreadsheet i use in work.

the spreadsheet is pretty much a list, but it has to be updated by several people within the office at the same time.

in the past if more then one person is tryin to save changes to the same cell then it will automatically shift one users changes down a row. lately tho we are getting a diolog box asking about a conflict and asking which users changes we want to keep. there is no option to keep both

any help would be greatly appreciated

Ian

edit: its excel 2003 by the way