I have a workbook that is periodically updated by a coworker and e-mailed to
me. The updated workbook is renamed with a new file name such as xxx rev4 and
the date it was updated. I would like to update my workbook without loosing
my comments that I have entered in workbook xxx rev3 and the date. How do I
update my workbook to the latest version without loosing my comments?

Thank you,

Master Chief

if I am reading this right, the only way of doing this is to have your
coworker edit xxx erv3 with the Track Changes feature turned on. He/she can
save it as rev4. You see the updates, but your comments will stay intact.

"Master Chief" wrote:

I have a workbook that is periodically updated by a coworker and e-mailed to
me. The updated workbook is renamed with a new file name such as xxx rev4 and
the date it was updated. I would like to update my workbook without loosing
my comments that I have entered in workbook xxx rev3 and the date. How do I
update my workbook to the latest version without loosing my comments?

Thank you,

Master Chief