LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Junior Member
 
Posts: 1
Post

I am having the same problem as Debra. And Bills workaround works for me too. The sheet is not protected nor share.

DOES ANYONE HOW TO FIX THIS PROBLEM?
shift + f2 does not work when trying to edit existing excel comments



Quote:
Originally Posted by Leif View Post
Share Workbook is turned off.

Bills work around also works for me.

"Debra Dalgleish" wrote:

If the workbook is shared (ToolsShare Workbook), you can only edit
comments that you have added since the file was last saved.

You can delete the existing comment (EditClearComments), and insert a
new one.

Could that be the problem?

Leif wrote:
Bill,

I have the same issue. I see no one answered your post. Did you find a
solution?

"Bill" wrote:


I have inserted comments in numerous cells on an excel spreadsheet and have
always been able to edit and insert new information, NOW I can no longer edit
any cell that has a comment inserted.
I can still insert new comments in an empty cell and edit them.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
edit Excel spread sheet Judy T New Users to Excel 3 March 24th 05 12:04 AM
Multiple excel users can open the same file and edit at the same . Jeff Howard Excel Discussion (Misc queries) 1 February 18th 05 12:19 PM
how to change default comment format in excel (2000) superiorparties Excel Discussion (Misc queries) 1 February 3rd 05 12:43 AM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 1 December 28th 04 02:50 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 12:51 PM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"