Tracking changes

C

cs

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.
 
M

Myrna Larson

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.
 
C

cs

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.




.
Click to expand...
 
Top