+ Reply to Thread
Results 1 to 2 of 2

Excel bug - cell comments become uneditable

  1. #1
    Registered User
    Join Date
    01-31-2009
    Location
    Romania, Eastern Europe
    MS-Off Ver
    Excel 2007
    Posts
    25

    Excel bug - cell comments become uneditable

    Sometimes I have this random problem that appears in Excel: the comment of a cell becomes "uneditable". I can see the comment as a tooltip if I hover above the cell, however if I select it and press Shift+F2 to edit its comment, nothing happens (the tooltip just "blinks" at every press).

    I get this problem periodically for various spreadsheets, and I haven't been able to link it to any one cause - it can happen for any type of cell, anywhere in the spreadsheet, in any spreadsheet. Furthermore, even if I save the file as Excel 2003-compatible (I normally use Excel 2007) and open it in Excel 2003, the problem remains.

    I should mention that I have not protected the workbook/worksheet, thus no cells are locked (although I did try protecting/unprotecting and locking/unlocking just to see whether this solves anything - it does not).

    What's interesting is that if I choose to Show All Comments, then all the comments can be edited - not by choosing Edit Comment or pressing Shift+F2 (that still doesn't do anything) but by directly clicking inside the visible comment. Since I have lots of comments in my sheet, however, I would rather not have them visible all the time.

    Has anyone come across this problem, and if so, managed to find a workaround for it? Anticipated thanks!

  2. #2
    Registered User
    Join Date
    01-20-2009
    Location
    Cliffside, NC
    MS-Off Ver
    Excel 2002
    Posts
    8

    Re: Excel bug - cell comments become uneditable

    I have this same problem on a spreadsheet. It is only comments that I've been editing every month for several years and now I cannnot edit these comments. I can't even edit these when I select "show all comments". I have a post titled "Edit comments not working for certain cells in a column Excel". I've been working in Excel for 25 years and have never seen this problem.
    We need help.

+ 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