A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't Edit Worksheet Comments



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 02:21 PM posted to microsoft.public.excel.worksheet.functions
Paul Calcagno
external usenet poster
 
Posts: 13
Default Can't Edit Worksheet Comments

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.

All of a sudden only one (of many) worksheets inside one particular (xlsx)
Excel file will not allow me to edit the comments in any of the cells where
the comments exist. When I right click the cell and select `Edit Comment'
(which is not greyed out) nothing happens. If I try this on any other xlsx
files I have or any other xls files, comment editing works fine. I tried the
help manual and a reboot to no avail.
I've been using/modifying this file for years. It contains tons of comments
that need updating all the time. Comment editing on any other xlsx files, or
in any cells on any other worksheet within this file or other files is
allowed just fine.
This file (and some of the other worksheets in it) has links that I
routinely enable. Would this somehow be causing this problem? My other xlsx
and xls files also have links but I have no problem editing comments in
those files. Any help would be greatly appreciated.

I thought of doing a reboot and then selecting `Last Known Good
Configuration' but don't want to dump anything I may have downloaded.


Thanks.......Paul C.


  #2  
Old June 4th, 2010, 02:26 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Can't Edit Worksheet Comments

Check your other post.

Paul Calcagno wrote:

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.

All of a sudden only one (of many) worksheets inside one particular (xlsx)
Excel file will not allow me to edit the comments in any of the cells where
the comments exist. When I right click the cell and select `Edit Comment'
(which is not greyed out) nothing happens. If I try this on any other xlsx
files I have or any other xls files, comment editing works fine. I tried the
help manual and a reboot to no avail.
I've been using/modifying this file for years. It contains tons of comments
that need updating all the time. Comment editing on any other xlsx files, or
in any cells on any other worksheet within this file or other files is
allowed just fine.
This file (and some of the other worksheets in it) has links that I
routinely enable. Would this somehow be causing this problem? My other xlsx
and xls files also have links but I have no problem editing comments in
those files. Any help would be greatly appreciated.

I thought of doing a reboot and then selecting `Last Known Good
Configuration' but don't want to dump anything I may have downloaded.

Thanks.......Paul C.


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.