Who change my data

[lovina]

One file with many users. The data keep changing but don't know who did
it.
Can we find otu who did it beside asking each of them?

Thanks

 

[Debra Dalgleish]

If you share the workbook (Tools>Share Workbook), you can track who
makes changes.

Some features, such as creating charts conditional formatting, are
disabled in a shared workbook. For more information on shared workbooks,
look in Excel's Help, under the topic 'Features that are unavailable in
shared workbooks' or view the list at the Microsoft site:

Features that are unavailable in shared workbooks
http://office.microsoft.com/en-ca/assistance/HP052010801033.aspx

 

[lovina]

Hi Debra,
Thanks for answering my question. So, another word if I shared on
folder and assigned to specific group and all member in that group ca
add or delete files inside the folder but if I shared the workbook i
the shared folder I can see who change the file but if I don't creat
shared folder I can not see who change the file. am I right?

Thanks.

lovin

 

[Debra Dalgleish]

I was referring to creating an Excel workbook that is shared.
To turn on that feature in a workbook, on the Excel menu bar choose
Tools>Share Workbook
Add a check mark to 'Allow changes by more than one user at the same time'
Click OK, and click OK to any messages that appear.

Later, to see who has made changes, choose Tools>Track Changes>Highlight
Changes
You can highlight the changes on the screen or list the changes on a new
sheet.