Hi,

I have a large spreadsheet (hundreds of columns) with scores of comments
attached to various column heading cells. If I insert a column toward the
left edge of the table and then immediately delete it, some of the comments
are automatically moved and resized in an apparently random fashion.
Sometimes the height or width of the comment is completely zeroed out, making
the comment invisible.

I have tried all three of the comment move/size property settings (move and
size with cell, move but don't size, and don't move or size) in combination
with both settings of the lock aspect ratio property setting. Nothing helps.

The behavior I want is for comments to automatically move with cells, but
not to be resized automatically. As it stands, every time I cut and re-insert
selected columns within the sheet, I have to go back and resize and re-locate
my comments for other cells that were not directly involved in the cutting
and re-insertion.

Can anyone help?

Thanks,
Andrew