C
Colin Hayes
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...
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...