Excel 2007 : Comments in a linked workbook

[kd4dna]

Hi,

I have two separate workbooks that I need to link. I can copy and paste special, > paste link and everything is fine except there are no comments which were on the original workbook. Since the comments change as well as the data in the cells I need that to link as well. Is there something I'm missing?

Ron
kd4dna

[kd4dna]

I ended up just writing a macro to copy over the one column with comments.

Ron