If you're interested only in identifying changes, if you have the previous
version of the workbook saved under a different name, you could use the
COMPARE.XLA utility that Bill Manville and I wrote. It's available for
download from
www.cpearson.com. It's free.
On Wed, 18 Aug 2004 13:00:00 -0700, "cs"
wrote:
Is there a method to track changes besides sharing a
workbook. I'm in the middle of a conversion from Excel to
Access and I have to clean up the data before I can add it
to the Access tables. This may take me a couple of weeks
so in the meantime updates to the Excel sheets may occur.
This would not be adding a new row of information, rather
updating columns in the row so it's difficult to see what
changed. I want to disrupt the users procedures as little
as possible so if anyone knows of a behind the scenes way
of accomplishing this I would appreciate some help.