Thanks, Looks promising, I'll try it out.
-----Original Message-----
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.
.