+ Reply to Thread
Results 1 to 9 of 9

Cell comments not showing on mouseover in one workbook

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Bellevue, WA, USA
    MS-Off Ver
    Excel 2016
    Posts
    40

    Cell comments not showing on mouseover in one workbook

    In one workbook, cell comments don't display when I mouse over them. Works fine in other workbooks. Excel display options is set for comments to display on hover.

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

    I've tried closing and reopening the workbook, and exiting and restarting Excel. Same results.

    Excel 2016. Office 365 ProPlus version 1705 build 8201.2193.


    Any suggestions?

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,988

    Re: Cell comments not showing on mouseover in one workbook

    please attach your workbook
    you can remove everything from the workbook except a few comments

    to attach a workbook
    - click Reply
    - cick Go Advanced
    - look below for Manage Attachments
    - follow screen instructions

    thanks
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    05-13-2011
    Location
    Bellevue, WA, USA
    MS-Off Ver
    Excel 2016
    Posts
    40

    Re: Cell comments not showing on mouseover in one workbook

    Hm. Well, I copied the worksheet out to a new workbook, and saved it without VBA. And the cell comments work fine on that sheet in the new workbook now. I'll see what I can do to isolate the problem.

    Greg

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,988

    Re: Cell comments not showing on mouseover in one workbook

    Looks like you have solved your problem

  5. #5
    Registered User
    Join Date
    05-13-2011
    Location
    Bellevue, WA, USA
    MS-Off Ver
    Excel 2016
    Posts
    40

    Re: Cell comments not showing on mouseover in one workbook

    Not yet. I need the other sheets and the VBA.

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    3,988

    Re: Cell comments not showing on mouseover in one workbook

    My first thought was that your "comments" may have in fact been other objects designed to behave in a similar way
    BUT - by transferring everything to a new file you have disproved that thought

    Default comment settings apear here:
    File \ Option \ Advanced - Comment options appear in Display category
    BUT - this must be correctly set already - otherwise all workbooks would display the same symptoms

    The VBA to toggle those settings:
    Please Login or Register  to view this content.
    BUT - again this would set the global variable and would apply to all workbooks

    One way to mimic the symptoms:

    Please Login or Register  to view this content.
    That would leave other workbooks unaffected (unless open at the same time)


    Hover characteristics are not something we have much control over, so there is a possibility that your workbook could be corrupted in some way
    - in which case all you can do is to create a new file and move all your data and VBA.

  7. #7
    Registered User
    Join Date
    05-13-2011
    Location
    Bellevue, WA, USA
    MS-Off Ver
    Excel 2016
    Posts
    40

    Re: Cell comments not showing on mouseover in one workbook

    Okay, it turned out that the problem was that I have a linked picture on another sheet in the workbook. 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. But of course you can't deploy it like that to users.

    That, too, was fixed when I deleted the linked picture.

    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 I'm 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 combobox's 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 that's a very minor complaint.

    I'm VERY glad to not have to choose between linked pictures vs. validation dropdowns & cell comments!

    Also, confirmed that this bug first appeared in Excel 2013. So tired of MS not fixing Excel bugs. I've 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. This particular bug isn't about VBA, but it happened in a workbook for which I'm doing VBA automation for a client. I won't say who the client is, but let's just say it's a little ironic! ;-)
    Last edited by GJL65; 09-28-2017 at 06:54 PM.

  8. #8
    Registered User
    Join Date
    01-03-2018
    Location
    brussels
    MS-Off Ver
    2010
    Posts
    1

    Re: Cell comments not showing on mouseover in one workbook

    @GKL65 I have the exact same issue you are describing and I also want to keep my linked picture.
    I am going to try the work around you describe and see if it works.

  9. #9
    Registered User
    Join Date
    07-21-2013
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Cell comments not showing on mouseover in one workbook

    This has to qualify as one of the strangest work-arounds ever!

    I had the problem on a worksheet that I used the Camera tool to show part of the sheet on a "dashboard", too. Once I added the combobox the comments showed on hover.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1