PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup tracking changes within a workbook

Reply

tracking changes within a workbook

 
Thread Tools Rate Thread
Old 11-05-2004, 03:59 AM   #1
sophie
Guest
 
Posts: n/a
Default tracking changes within a workbook


Hi
I have a file set that several users can access and make
changes to. The problem is that I am noticing errors and
in the worksheets eg random cells deleted/added and so
staggering the file that I know I haven't made but cannot
find who is in order to pervent it from happening again.
I need to continue to allow access to other users, but I
would like to track what changes are being made and by
whom. Is it possible to do this? I clicked on track
changes but it seems to be related more to Outlook than my
excel file.
Thanks!!
Soph
  Reply With Quote
Old 13-05-2004, 01:23 AM   #2
Steven Castelletto
Guest
 
Posts: n/a
Default tracking changes within a workbook

If you click on tools and then share workbook there is a
checkbox there that needs to be clicked first before you
can track changes made by users.
After checking this box you can then click on the
advanced tab to view different options for keeping track
of changes made by your users.
To view track changes you will simply then need to click
on tools and then track changes which will then give you
the option of highlight changes and accept or reject
changes. By choosing highlight changes you will be given
some options of how you would like to view the changes
that have made.
One of them being a WHO option...
Hope this helps
>-----Original Message-----
>Hi
>I have a file set that several users can access and make
>changes to. The problem is that I am noticing errors

and
>in the worksheets eg random cells deleted/added and so
>staggering the file that I know I haven't made but

cannot
>find who is in order to pervent it from happening

again.
>I need to continue to allow access to other users, but I
>would like to track what changes are being made and by
>whom. Is it possible to do this? I clicked on track
>changes but it seems to be related more to Outlook than

my
>excel file.
>Thanks!!
>Soph
>.
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off