Shared spreadsheet keeps altering formatting

Hi,

Can anyone help - We are using a spreadsheet at work which basically logs the calls received by our dept.

The cells are changed to a specific colour depending on if the call is completed / delayed / requiring action etc so that the can be sorted into these areas.

The workbook is shared so that anyone within the team can see the spreadsheet and where that call is up to.

Problem is - when someone opens the sheet then the data appears differently (i.e not sorted / colours have changed / data has moved into different sections / size of the cells has changed) to that last saved by another individual.

I have made sure all the guys are saving the worksheet as the same excel version (2007) but the problem is still persisting.

Any ideas - I really need the sheets to llok the same regardless of when or who opens it.

Please help

Thanks

Christine