The last instruction was to turn on Automatic Calculation Now all is good.

Excel display options is set for comments to display on hover.

Works fine if I change the options setting to always display, but thats not what I need.

Ive tried closing and reopening the workbook, and exiting and restarting Excel.

Office 365 ProPlus version 1705 build 8201.2193.

Any suggestions.

And the cell comments work fine on that sheet in the new workbook now.

And there is a bug with linked pictures that prevents cell comments from displaying, at least most of the time (on rare, apparently random occasions they would display).

If I delete the linked picture, the cell comments immediately start working correctly, and consistently.

I discovered this when I tried to make a data validation dropdown on another sheet in the workbook.

The dropdown arrow only appeared if I held the mouse down on the cell.

If I then slid my mouse over to the dropdown arrow, I could click on it and select an item from the dropdown.

The problem now is that I really wanted linked pictures for the Dashboard sheet.

Linked pictures allow creating dashboard elements without concern for conflicting needs between elements regarding column widths and row heights.

Next step Im going to look into how others are dealing with the dilemma -- do I really have to choose, or is there some way of using all of those features Apparently this bug has been around since Excel 2013, which is not a good sign.

UPDATE: The weird workaround is to put a forms control combobox (note, not an ActiveX combobox) on each affected sheet, with the comboboxs input range set to the entire sheet (1:1048576).

The dropdown flashes when you first click on the cell, and sometimes the cell comments do the same, but thats a very minor complaint.

Im VERY glad to not have to choose between linked pictures vs.

Ive been automating Excel since version 4 in 1992 (before VBA), and it seems like I spend more and more of my time working around Excel bugs.

I wont say who the client is, but lets just say its a little ironic;-).

I am going to try the work around you describe and see if it works.

I hope you can convince your client to convince the Excel support team to look at this little problem sooner than 2020.

I tried adding a combo box per GJL65s suggestion, and it did not help.

Once I ungrouped the radio buttons, the comments began working correctly.

It turns out I inadvertently didnt allow the macro to finish.

Excel For Mac Comment Not Showing