Shared workbook.

New Contributor

Good day, I am using Windows 10 Pro, I think Office 6. 

We are 4 persons sharing workbooks. I want to find out if there is a way to distinguish who add specific data into the workbooks. Is there a way that it can be highlighted a certain colour, if say for instance 
I added data and it would be green, the next persons red and so on.

2 Replies

@Retha950  You could write a macro to do what you want, but there is an old feature in Excel to track changes.  You can get to it by adding the menu options in using the OPTIONS menu:

mtarler_0-1624544832645.png

As you can see it is listed as (Legacy) and on the right you can see I have created a custom subfolder called Audit Trail with both Track Changes and Share Workbook because you need both options.

Once you have them select 'Share Workbook' and click the box to use it instead:

mtarler_1-1624544991164.png

After selecting this box go to the Advanced tab and adjust settings as you prefer (e.g. increase track history time from 30 days to some sufficiently long time like 9999 days.

Then you can make setting changes in Track changes.  The changes can show up as little triangle that pop up with comments about the change or you can create a new sheet to show a history of all changes (i.e. audit trail).  Note you have to save the document for it to update.

If this doesn't work for you or you don't like how it works, then I guess a custom macro would be your next option.

 

 

Thank u so much, I will try it. Much appreciated.