Excel 2007 Shared Workbook Saved changes not applied correctly
 

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.

Excel 2007 Shared Workbook Saved changes not applied correctly
 

Hi,

Please let me know if you managed to resolve this issue, as I think
something v. similar is happening on our system - but note we are not using
Vista, just XP.

Excel 2007 Shared Workbook Saved changes not applied correctly
 

I have found the problem has nothing to do with Vista. The problem is in
Excel 2007. I have narrowed down the problem to an exact sequence and I have
issued a case with Microsoft and they have confirmed it to be a bug. I am
still waiting for the fix.

"Lambs" wrote:

Hi,

Please let me know if you managed to resolve this issue, as I think
something v. similar is happening on our system - but note we are not using
Vista, just XP.