Results 1 to 6 of 6
  1. #1
    3 Star Lounger djmoore's Avatar
    Join Date
    Feb 2001
    Location
    New Jersey, USA
    Posts
    371
    Thanks
    21
    Thanked 1 Time in 1 Post

    tracking changes (Excel 97 SR2)

    I maintain a spreadsheet with sensitive information and want to move it from a secure network drive to a common network area with password protection. The people with access are supposed to annotate all changes with names and dates, but don't always do so. Is there any way to track all changes to the spreadsheet?

    djm
    Have a cookie -

    Don

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tracking changes (Excel 97 SR2)

    I do not know of any way to automatically track changes in Excel. You could put code in the Workbook Change Event routine to track all changes, possibly by appending to the cell comment of the cell being modified.

    One word of caution. Excel passwords are notoriously easy to break. Just use google to search for Excel lost password to find a list of Excel password crackers. The crackers can usually find the password in just a few minutes.
    Legare Coleman

  3. #3
    3 Star Lounger djmoore's Avatar
    Join Date
    Feb 2001
    Location
    New Jersey, USA
    Posts
    371
    Thanks
    21
    Thanked 1 Time in 1 Post

    Re: tracking changes (Excel 97 SR2)

    Thanks for the info - I'm not too clear on what it means but I'll do some checking at my end. As for cracking the password, the data isn't really secret - it just needs to be accurate. I only want to keep out the people who would screw up the data because they didn't know what they were doing, but thought they should do it anyway because they're too stupid to know otherwise.
    Have a cookie -

    Don

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: tracking changes (Excel 97 SR2)

    Have you tried Tools, Track Changes ?

    It allows changes to be listed in a History sheet, and is worth checking out.


    Andrew C

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tracking changes (Excel 97 SR2)

    I had completely missed that feature. I knew it existed in Word, but missed it in Excel. It does look like exactly what he is looking for.
    Legare Coleman

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tracking changes (Excel 97 SR2)

    Just a comment here. The tracking feature isn't available if the workbook is protected (as are a few other Excel features). I had to let my users have access to that but also protect the worksheets so I ended up writing code to protect formulas and some cells which wasn't trivial.

    FWIW, Deb <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •