I am having an issue with one of my customers shared excel document. There is around 4 people that use the document, three use excel 2007 & one uses excel 2010. What happens is, they regularly add comments to cells in the document then save it & then when they re-open it, some of the comments have disappeared completely. At first I though it could be an issue with it being a shared file and when another person saves, it overwrites changes, however the data that has been inputted in the cell is still there, just some comments go missing.
Any ideas would be appreciated.