Results 1 to 6 of 6

Thread: Tracking Changes

  1. #1

    Exclamation Tracking Changes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to be able to track changers that have been made to workbook that was emailed out to people.
    Ex: I create the sheet - tell it that I would like it to highlight the changes made by others - I email it out to some people - they change things and send it back to me - - - - so far i cannot get excel to highlight the changes made by people before they email it back to me.

    -if there is a way to do this, and I am just going about this wrong, PLEASE let me know.

    Thanks!

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,744
    Articles
    76
    Blog Entries
    14
    The change tracking features in Excel tend to make workbooks very unstable, and most experts you find will advise you to never, ever, ever turn that feature on.

    Personally, I'd set up another sheet to capture data entry from other users, or possibly use a macro to record what cells were edited if you can't have them enter into a new sheet.
    Ken Puls, CPA, CMA, FCMA, MS MVP (Excel)

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    184
    Articles
    0
    Is making the workbook a shared workbook the same thing as having the change tracking?
    Is it safe to make a shared workbook, but then in the advanced settings, make sure to check the "Don't keep change history" option?

    I have a workbook, that most of my vba questions have been about, that is shared. I have 1 person who constantly complains about data going missing, or not staying sorted. I use the same file everyday and don't seem to have the same issues as the other guy, not sure if I just save more often than him or what.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,744
    Articles
    76
    Blog Entries
    14
    Hi Simi,

    I avoid shared workbooks like the plague. I've just heard of way too many problems with them, change tracking on or off.

    If I need a shared environment, I create a database and use VBA code to push/pull to/from the database. In this way I can make sure that no data ever enters the system unless it is valid, and that the data is always up to date.
    Ken Puls, CPA, CMA, FCMA, MS MVP (Excel)

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Hi Ken, would you happen to have an example of this Push/Pull system you could share? What database software would you use?

    Gary

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,744
    Articles
    76
    Blog Entries
    14


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Gary,

    I just use Excel to push/pull to/from Access or SQL Server. The basic philosophy behind my approach is cotained in these two articles:
    Ken Puls, CPA, CMA, FCMA, MS MVP (Excel)

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

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