Hi All

I have a worksheet upon which I use the 'Refresh All' command to receive
data from an external source. It works well.

I also like to insert Comments on the sheet. I find however that when I
use the 'Refresh All' command the formatting of the sheet is changes
such that the 'Insert Comment' link disappears from the context menu.

How can I stop the Refresh All command changing the format of my sheet ,
and leave me the option to insert a Comment?

I tried to use the data Range Properties command on the External Data
toolbar , but it is constantly greyed out.

Grateful for any ideas...