Log of Transactions
 

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

Log of Transactions
 

I assume worksheet means workbook.

You can share the workbook under ToolsShare 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

On Fri, 26 Oct 2007 15:22:00 -0700, Snakeoids
wrote:

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