I frequently send out Excel workbooks to colleagues and ask them to
update cells. They are in different locations. I ask them to highlight
each cell that they change so I know what was changed. This works as
long as they remember to shade the changed cells.

I have heard about Track Changes.Would this be my solution? I am not
sure I am able to create a shared workbook when they are in different
buildings.

Read Bob Phillips he

http://groups.google.com/group/micro... ff4dd28287a89