The persons working with the shared workbook should hit Cntrl+S before / after entering any new data and to view the changes done by the other users.

Refer the below links to know more about how to work with shared workbook.

http://www.excelforum.com/excel-form...ing-issue.html

http://www.excelforum.com/excel-gene...opening-2.html