Nobody at Microsoft can explain comments :)

I have a file with a major use for comments - its a real pain in the neck.
Like you say they jump up all over the place when you go to edit them.
you can't search them (easily)

They could have been a really useful addition but imo they (microsoft)
missed a trick here.



On Tue, 18 Jul 2006 15:46:16 +0100, DB. wrote:

I have two workbooks which have comments on a few of their cells.
As is appropriate, when I point to each of those cells the comments
they
contain appear alongside.
But often (not always), after I have saved the workbook then opened
it
up again on my return, I find that none of my comments appears when I
point
at it.
Comments can be made visible again by selecting any cell containing a
comment, clicking Insert -- Edit Comment, then exiting without changing
anything. All comments on that worksheet are now available to me.
Next time I return to the workbook my comments may be available - or,
equally, they may not.
Can anyone explain to me what is happening here, please?




--
Steve (3)