+ Reply to Thread
Results 1 to 6 of 6

Is it possible to show who last updated a cell on a spreadsheet and when they did it?

  1. #1
    Registered User
    Join Date
    12-06-2013
    Location
    bristol england
    MS-Off Ver
    Excel 2007
    Posts
    6

    Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    Hi all,

    Is it possible to set something up on a spreadsheet which shows who last updated a cell and when they did it? I have a huge spreadhseet with lots of data on which gets updated by a number of users, they update a lot of different cells and this leads to errors being made with the data in the spreadsheet.

    I am hoping there is a way I can show who updated a cell and what date - is this doable??

    Many thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,252

    Re: Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    You can create an audit log for the worksheet or the whole workbook. However, you'd need VBA and that means you must force the users to enable macros ... or open the workbook from a trusted location.

    That involves hiding and unhiding sheets so that the workbook is unusable without enabling macros

    If you do decide to go for it, one way or another, you could track before and after values.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    Does the 'Track Changes' functionality not provide what you want?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,252

    Re: Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    @OllyXLS: never thought of that. Downside is that it makes the workbook Shared which is not something we would normally encourage.

    Regards, TMS

  5. #5
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    Quote Originally Posted by TMShucks View Post
    @OllyXLS: never thought of that. Downside is that it makes the workbook Shared which is not something we would normally encourage.

    Regards, TMS
    Indeed - but at least it would use standard functionality, and therefore probably remain easier to develop and support, than a custom VBA solution. Pros and cons to all approaches, here!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,252

    Re: Is it possible to show who last updated a cell on a spreadsheet and when they did it?

    Pros and cons to all approaches, here!
    Absolutely! I'm not actually saying a VBA solution is a good one, just a possibility. Pain to set up anyway!

    Probably better to lock formula cells, apply Data Validation, and protect worksheets ... again, standard functionality.
    Last edited by TMS; 12-06-2013 at 08:24 AM.

+ 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] Help!! I need a picture to show in a spreadsheet based on a cell value!
    By shannon3778 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2012, 10:09 AM
  2. Replies: 0
    Last Post: 06-20-2012, 10:58 AM
  3. Replies: 2
    Last Post: 06-30-2009, 02:59 PM
  4. Need formula to show if a field hasn't been updated
    By telewats in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2006, 03:34 PM
  5. Replies: 1
    Last Post: 02-08-2005, 12:06 PM

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