+ Reply to Thread
Results 1 to 8 of 8

Tracking changes in a spreadsheet

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    NY
    MS-Off Ver
    2013
    Posts
    8

    Tracking changes in a spreadsheet

    Hello,

    I'd like to be able to track who opens or makes any changes to a spreadsheet. Is there a way to do that without it being obvious? Mostly I want to know who opens it, but making changes is a secondary need.

    Thank you in advance! Sorry if this is a dumb question.

  2. #2
    Registered User
    Join Date
    04-30-2015
    Location
    NY
    MS-Off Ver
    2013
    Posts
    8

    Re: Tracking changes in a spreadsheet

    And by "not being obvious", I would prefer that it be somewhat hidden or not noticable.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Tracking changes in a spreadsheet

    Not a dumb question.

    To know who is opening a spreadsheet, you'd need to use macros (VBA) and the person opening it would need to enable macros. So probably not a great option unless it's already a macroed workbook
    To track changes on a spreadsheet, you'll need to save it as a shared workbook. Then on the Review tab, "Track Changes>Highlight Changes. I prefer checking "List Changes on a New Sheet" and uncheck everything else. Excel will create a nonsavable worksheet showing who made what changes.
    Does that help?
    ChemistB
    My 2Ę

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Tracking changes in a spreadsheet

    Hi,

    The easiest way to monitor who opens the workbook (and when) is to use the Workbook Open Event VBA procedure and a hidden sheet.

    In that procedure include an instruction like

    Please Login or Register  to view this content.
    If you need to capture information about what changes are made then you could use the Sheet Change Event. e.g. assuming you want to capture changes in say columns C:E on a sheet called "hidden_sheet_name" then something like...

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Tracking changes in a spreadsheet

    Hi Richard
    When I copy your code over, I get compile errors ("Excpected: List seeparator or )" ) on the lines copying the changes into the hidden sheet. It always highlights the letters in quotes i.e. "C" or "E".

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Tracking changes in a spreadsheet

    Hi,

    My apologies. I was using the VB sheet code name in my test but when I added the code here I changed to a tab name and I see I missed out a pair of quotes. So in lines which have

    Please Login or Register  to view this content.
    that should of course read

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor S O's Avatar
    Join Date
    06-25-2015
    Location
    England
    MS-Off Ver
    Office 2010 + 2013 + 2016
    Posts
    103

    Re: Tracking changes in a spreadsheet

    You could use the workbook open event:

    Please Login or Register  to view this content.

  8. #8
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Tracking changes in a spreadsheet

    Thanks Richard,
    I should have caught that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Money tracking spreadsheet
    By segagesi in forum Excel General
    Replies: 19
    Last Post: 01-13-2017, 09:00 AM
  2. [SOLVED] Audit Tracking Spreadsheet
    By excelrookie82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2014, 08:44 PM
  3. Tracking review spreadsheet
    By tivory in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2013, 11:08 AM
  4. VAT weekly tracking from spreadsheet
    By Trugmaker in forum Excel General
    Replies: 0
    Last Post: 05-18-2010, 01:33 PM
  5. Tracking Spreadsheet
    By Tuttamay in forum Excel General
    Replies: 2
    Last Post: 01-21-2005, 10:36 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1