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.

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.

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.

.