The information cannot be pasted because the Copy error..

Originally Posted by shg

You are trying to paste to an Excel 2007 workbook that is NOT in compatibility mode?

I am using Excel 2007.

The worksheet with the data does not have Compatability Mode next to the file name, but the destination worksheet does have Compatability Mode next to the file name. HTH

Thanks!