ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comments in a shared Workbook acting strangely (https://www.excelbanter.com/excel-discussion-misc-queries/145482-comments-shared-workbook-acting-strangely.html)

J Streger

Comments in a shared Workbook acting strangely
 
I have a shared workbook shared across a LAN. Each person has their own sheet
to edit. I have to edit the sheet each time around by shifting data (and the
comments that go with it). I do this programatically. Regardless, every month
neither me or the other user can edit the comments that exist on the sheet.

I can select Edit comment, highlight all the data or put my cursor in the
old data anywhere, but cannot add/delete/edit the old data. I can tack new
information on just fine. I can delete the comment and create a new one that
is totally editable. has anyone experienced this and know what is happening
here? We are using Excel 2003. Thanks.

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003


Debra Dalgleish

Comments in a shared Workbook acting strangely
 
That's the way comments are designed to work in a shared workbook.

J Streger wrote:
I have a shared workbook shared across a LAN. Each person has their own sheet
to edit. I have to edit the sheet each time around by shifting data (and the
comments that go with it). I do this programatically. Regardless, every month
neither me or the other user can edit the comments that exist on the sheet.

I can select Edit comment, highlight all the data or put my cursor in the
old data anywhere, but cannot add/delete/edit the old data. I can tack new
information on just fine. I can delete the comment and create a new one that
is totally editable. has anyone experienced this and know what is happening
here? We are using Excel 2003. Thanks.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:43 PM.

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