Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count transactions below a threshold | Excel Discussion (Misc queries) | |||
The goal is 5 per 100 transactions, how do I write formula for % | Excel Discussion (Misc queries) | |||
couting transactions for same time | Excel Worksheet Functions | |||
Finding Matching (ContraSide) Transactions | Excel Worksheet Functions | |||
counting with a criteria in multiple transactions | Excel Worksheet Functions |