L
Lady G
I am having a problem with editing comments in a shared 2003 workbook (the
workbook and worksheets are not protected). Older comments (not Data
Validations) must be shown (using the show/hide comments command) before they
can be accessed for editing. Some of the newer comments still seem to retain
the one-right-click access to edit but the Right click, edit comments command
does not have any effect on the older comments (nor does going in through the
view menu). I don't know if it matters, but I have been unable to determine
exactly how far back this goes with regards to when the comments were created.
My workbook file contains at least a thousand comments (making me loathe to
recreate the file and comments one by one). Any ideas on why the edit
comment function would cease to work? Better still, any ideas on how to
automate a fix and avoid this problem in the future?
P.S. In the interests of efficiency: the worksheets are not grouped; the
display properties are set at comment indicator only; the problem exists on
this file on multiple PCs and persists when portions of the sheet are copied
to new blank workbooks, but does not extend to non-related workbooks with a
similar number of comments. Appears limited to this workbook only (for now).
workbook and worksheets are not protected). Older comments (not Data
Validations) must be shown (using the show/hide comments command) before they
can be accessed for editing. Some of the newer comments still seem to retain
the one-right-click access to edit but the Right click, edit comments command
does not have any effect on the older comments (nor does going in through the
view menu). I don't know if it matters, but I have been unable to determine
exactly how far back this goes with regards to when the comments were created.
My workbook file contains at least a thousand comments (making me loathe to
recreate the file and comments one by one). Any ideas on why the edit
comment function would cease to work? Better still, any ideas on how to
automate a fix and avoid this problem in the future?
P.S. In the interests of efficiency: the worksheets are not grouped; the
display properties are set at comment indicator only; the problem exists on
this file on multiple PCs and persists when portions of the sheet are copied
to new blank workbooks, but does not extend to non-related workbooks with a
similar number of comments. Appears limited to this workbook only (for now).