Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    unable to edit cell comment (Excel 2003 SP3)

    When I try to edit an existing cell comment by "right click, edit comment", nothing happens...

    Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    Does this happen in a particular worksheet? If so, check whether the worksheet is protected.
    In all worksheets in a particular workbook?
    In all worksheets in all workbooks?

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    It happens in a particular worksheet. That sheet is unprotected.
    It's only one worksheet in a workbook.
    Not all worksheets in all workbooks...

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    Are you sure they are comments? perhaps it is datavalidation...

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    Does Shift+f2 do anything?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    If you wish, and if the comments are not sensitive, you could attach (a copy of) the workbook - you can clear the cell contents.

  7. #7
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unable to edit cell comment (Excel 2003 SP3)

    Mysteriously, the problem seems to have fixed itself !

    Needless to say I am somewhat bemused.

    I will advise if it recurs...

    Thanks much to all !

Posting Permissions

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