Shaun,
I had the same difficulties a few months back - after googling til I went google, I never actually did solve the problem. It seems to only affect columns A & B.
I managed to work around it as the data that was scrambled was data I didn't need at that time.
I might go to MrExcel to see if I can find a solution.