Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 05, 05:55 PM
Bill
 
Posts: n/a
Default I am unable to edit a comment in excel

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.

  #2   Report Post  
Old May 26th 05, 06:12 PM
Leif
 
Posts: n/a
Default

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.

  #3   Report Post  
Old May 26th 05, 06:33 PM
Bill
 
Posts: n/a
Default

Leif
No, I still have the same problem, I have asked various so called experts,
but to no avail.
I am glad that you replied I thought that it was me.

Rgds

Bill

"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.

  #4   Report Post  
Old May 26th 05, 06:37 PM
Debra Dalgleish
 
Posts: n/a
Default

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

  #5   Report Post  
Old May 26th 05, 06:58 PM
Bill
 
Posts: n/a
Default

Yes it would create a problem, I can edit by right clicking the cell scroll
down to "show/hide comments" the comment box is then open and I can edit,
when I finnish I then have to go back to "show/hide comments" and close the
box which is just to long, it is much quicker to go to insert and click on
"edit comment".

"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




  #6   Report Post  
Old May 26th 05, 08:39 PM
Leif
 
Posts: n/a
Default

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


  #7   Report Post  
Old January 30th 14, 06:15 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2014
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



Reply
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 01: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 01:19 PM
how to change default comment format in excel (2000) superiorparties Excel Discussion (Misc queries) 1 February 3rd 05 01:43 AM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 1 December 28th 04 03:50 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 01:51 PM


All times are GMT +1. The time now is 05:32 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017