Office setup is 1 system running Vista Business and 4 systems running XP Pro.
All systems running Office 2007.

Problem:
1. User "A" and user "B" open a shared workbook hosted on the Vista system.
2. User "A" sorts their sheet and makes changes to rows 10-15 for example
and saves changes.
3. User "B" without doing any sorting does a save to get the applied
changes. He checks for the changes and finds them in rows 10-15 but the rows
that should have been changed are his rows 30-35.
4. If user "B" then saves and user "A" saves to get changes, user "A" then
has the changes as were viewed by user "B" and not the original changes user
"A" made.

This problem has only occured since going to Office 2007. Previous version
was Office 2003 and never had problems. The problem also is random, it does
not happen everytime.

The current work around at this time is for each user to only do 1 save then
exit the shared workbook and then reopen it. We have also found that they
need to wait a bit before the reopen or none of the changes are there.

If anyone can shed some light on this it would be greatly appreciated. I
think we have discovered a major bug in Excel 2007.