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?

--
DB.

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)

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?



"SteveW" replied:

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.


Thanks, Steve.

I now notice that if I have my worksheet (comments available) open in
one window and open Outlook Express in another, then the comments are no
longer available. But my workbook has two sheets, and if I tab to the other
sheet, then tab back again I get the comments again!
I imagine your "Nobody at Microsoft can explain comments :)" may best
sum it up!
--
BW's,
DB.

Why can't you search them easily?

Edit|find|Options button|Look in Dropdown|Comments

"DB." wrote:

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?


"SteveW" replied:

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.

Thanks, Steve.

I now notice that if I have my worksheet (comments available) open in
one window and open Outlook Express in another, then the comments are no
longer available. But my workbook has two sheets, and if I tab to the other
sheet, then tab back again I get the comments again!
I imagine your "Nobody at Microsoft can explain comments :)" may best
sum it up!
--
BW's,
DB.

--

Dave Peterson

I don't have an Options button :)
But thanks for the reminder.
This does work, but for some reason you can't have Formula and Cells




On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
wrote:

Why can't you search them easily?

Edit|find|Options button|Look in Dropdown|Comments

"DB." wrote:

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?


"SteveW" replied:

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.

Thanks, Steve.

I now notice that if I have my worksheet (comments available) open
in
one window and open Outlook Express in another, then the comments are no
longer available. But my workbook has two sheets, and if I tab to the
other
sheet, then tab back again I get the comments again!
I imagine your "Nobody at Microsoft can explain comments :)" may
best
sum it up!
--
BW's,
DB.




--
Steve (3)

What do you mean by Formula and Cells?

If you mean: Formula and Comments?

Then, yep. You have to do it twice.





SteveW wrote:

I don't have an Options button :)
But thanks for the reminder.
This does work, but for some reason you can't have Formula and Cells

On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
wrote:

Why can't you search them easily?

Edit|find|Options button|Look in Dropdown|Comments

"DB." wrote:

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?


"SteveW" replied:

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.

Thanks, Steve.

I now notice that if I have my worksheet (comments available) open
in
one window and open Outlook Express in another, then the comments are no
longer available. But my workbook has two sheets, and if I tab to the
other
sheet, then tab back again I get the comments again!
I imagine your "Nobody at Microsoft can explain comments :)" may
best
sum it up!
--
BW's,
DB.


--
Steve (3)

--

Dave Peterson