Log of Transactions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,
I've set up a worksheet for a group of users to add, change, or delete data
in various columns. However there's a problem with the data being rearranged
out of order. I can't figure out what's going wrong, but I have an idea.
I believe that Excel has some sort of Log that can be activated for a
worksheet. It basically keeps track of all changes and records things like
user, time, change performed, etc. Can you tell me how to activate this
feature please? It's been a while and I'm not sure where to find it. Thank
you.
Rod
 
I assume worksheet means workbook.

You can share the workbook under Tools>Share Workbook and allow change tracking
with a history sheet to keep track of who, when and what.

See help on shared workbooks and track changes.

Note the loss of some features and functionality with shared workbooks.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transaction log? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Outlook Tracking category changes 1
Insert 3 blank rows wherever the date changes in column???? 8
Worksheet Formula Issues 3
Tracking Access in Read-Only Files 0
Macro to find value and then copy associated range 1
If - Then - Now what? 1

Back
Top