ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't Edit Cell Comments (https://www.excelbanter.com/excel-discussion-misc-queries/265177-cant-edit-cell-comments.html)

Paul Calcagno

Can't Edit Cell 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.


Paul Calcagno

Can't Edit Cell Comments
 
Haven't heard from anyone all day. You guys must be busy. Anyone care to
take a gander at why I can't edit my Excel `07 comments?
Thanks...........Paul C.

"Paul Calcagno" wrote in message
...
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.




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com