Inserting Comments In A Shared Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've recently been working in a shared workbook with up to four others users
and using the Insert Comment function. However, despite regularly saving the
changes, the bulk of my comments disappeared after I exited and re-entered
the spreadsheet. I'm led to believe that this can happen in shared workbooks
that contain a lot of data as the one in question does. Has anyone else
experienced this issue and/or know a solution to the problem?
 
Is it the comments that are missing or is it the comment indicators.

I just shared a workbook, inserted a comment, saved, and reopened
and the comment was there. Did you save your workbook.

Since there is no point to me sharing a workbook I have very limited
experience, other than to say I won't use the option and don't have to
share with anyone for any reason. My own experience into shared
workbooks for highlight chnages is in
Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm

and getting rid of it without restoring from a backup can be done with
Tools --> Share Workbook --> uncheck option
 
I am getting similar remarks on a sporadic basis from a couple of users in
our business. We have upgraded all editing users to Excel 2003 on top of
Windows XP Professional running on a mix of laptops and desktops. We use
Windows 2003 Server to manage the shared directory. We also have a couple of
people using Excel 97 in read only mode accessing the workbook.
The spreadsheet we have varies in size up to around 15Mb but mostly is about
3Mb. We use some VB coding to allow allocation of resources with changes of
background colours and insertion of comments through some user click buttons.
It is only a couple of users having the problem sometimes. We have been
working on this off and on over the past four months without any "Eureka"
moments as to what can be causing the problem.
 
Another point worth checking is whether or not you have Edit Objects allowed
if you are protecting any worksheet within the workbook, as I understand that
a comment is an object.
With the workbook unshared, go to Tools, Protection, Protect Sheet, and
scroll down to the end of the activities that you are allowing all users to
access.
Now turn on workbook sharing with Tools, Share Workbook and tick the
checkbox to allow editing by more than one user at at time.
 
Back
Top