Odd problem with a shared book

[Twoslip]

Hello.

I have this really strange problem with a sheard file.
We are several people who work with the same file but this problem only happens to me.
I use Win7 as OS the others use WinXP, we all use Office2007.

Now to the problem.

When I write in a row and color it and save it, it looks good to me, but when someone else open the same file after I saved it my coloring sometimes jumps down on the row bellow.
Its kind of frustrating as we color the rows diffrently depending on progress.
What can be wrong?

 

[GlennUK]

I'd say that the workbook is corrupted. Take it out of Shared Mode, and then make it Shared again to reset it. I've seen this happen dozens of times, and I don't recommend Shared workbooks. Further reading:
http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

 

[Twoslip]

If it is a Shared book issue, shouldnt it affect all?
As this only happens when I have worked on it.

 

[GlennUK]

Once it's corrupt you can't predict what will be affected. That's the big problem ... you may not even notice when things go out of alignment ... as different people may see different things, and it may appear right to some/all of them.

 

[Twoslip]

Aha.
So just by unsharing and reshare again will solve the issue for now?

 

[GlennUK]

That's right.