Log file

[xlguru]

I have a file on the network, which is being used and modified by
multiple users. Is there any way to create a log file to track details
about changes made by different users. Details like username date time
etc.

 

[Debra Dalgleish]

You can share the workbook (Tools>Share Workbook), then turn on tracking
(Tools>Track Changes).

Some functions aren't available in a shared workbook though, so this
option might not be feasible for you.

XL: Commands and Features Unavailable in Shared Workbook
http://support.microsoft.com/default.aspx?id=130560

Features that are unavailable in shared workbooks
http://office.microsoft.com/assista...ID=HP052010801033&CTT=4&Origin=CH010003631033