Excel bug

longtalker · 01-22-2009, 10:30 PM

Sometimes in Excel, the comment of a cell becomes unusable. I can see the comment as a tooltip if I hover above the cell, however if I select the cell and press Shift+F2 to edit it, nothing happens (the tooltip just blinks at every press).

I get this problem periodically for various files, and I haven't been able to link it to any cause. It's most likely a bug in Excel; I use Excel 2007 but even if I save the file as Excel 2003-compatible and open it in Excel 2003, the problem remains.

I should also mention that I haven't protected the workbook/worksheet, thus no cells are locked (although I did try protecting/unprotecting and locking/unlocking, with no results).

If this all sounds too abstract, I made this visual demo of how the bug manifests itself: http://www.youtube.com/watch?v=LxeJgWjFr_E&fmt=18

Has anyone found a workaround for this?

01-22-2009, 10:30 PM	#1 (permalink)
longtalker New Member Join Date: Jan 2009 Posts: 7	Excel bug - cell comments become uneditable Sometimes in Excel, the comment of a cell becomes unusable. I can see the comment as a tooltip if I hover above the cell, however if I select the cell and press Shift+F2 to edit it, nothing happens (the tooltip just blinks at every press). I get this problem periodically for various files, and I haven't been able to link it to any cause. It's most likely a bug in Excel; I use Excel 2007 but even if I save the file as Excel 2003-compatible and open it in Excel 2003, the problem remains. I should also mention that I haven't protected the workbook/worksheet, thus no cells are locked (although I did try protecting/unprotecting and locking/unlocking, with no results). If this all sounds too abstract, I made this visual demo of how the bug manifests itself: http://www.youtube.com/watch?v=LxeJgWjFr_E&fmt=18 Has anyone found a workaround for this?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell phone Cell phone Cell phone Cell phone!	theasian100	Off Topic Chat	2	07-29-2008 07:06 AM
Splinter Cell string people bug lol	dazbizkit	Computer Games and Consoles	4	03-24-2007 10:53 PM
PSU 101	Praetor	Computer Cases, Power Supplies and Cooling	6	07-14-2006 03:15 AM
How do i... add text to MS Excel cell?	Scrat	General Software	2	06-29-2005 08:35 AM