log any changes to spreadsheet

L

Lynda

How can I log any/all changes made in one spreadsheet to another sheet?
I would like to keep a running log.
 
P

Pete

Look in Help for "history" or "Track changes" - you can tell Excel to
record an audit trail of changes made to a workbook, and this will give
you further information. I've never used it myself, so I can't give you
any further details.

Hope this helps.

Pete
 
K

Kevin M

I answered your original post on the previous page and Pete is right. Track
Changes is the only way to do it. Excel cannot keep a running list of changes
to one specific cell somewhere else, as soon as you change the data in the
originating cell it changes everything elsewhere too.

You can turn on track changes by choosing Track Changes from the tools menu,
it will share out your workbook and allow you to see the changes made by all
users. After that, you can go into Track changes and view them all. The
changed cells will also have colors associated to the user.

HTH
Kevin M
 
Top