Article ID: 931398 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
You copy a cell in a Microsoft Office Excel 2007 workbook by using Microsoft Office Excel 2003 with the Microsoft Office Compatibility Pack for Excel 2007 file formats installed. Then, you use the Paste Special feature to paste a link to the copied cell into a new workbook. When you do this, the destination cell in the new workbook contains the following value:
This problem occurs because of a problem with the way that the Paste Special feature works in this case.
To work around this problem, save the new workbook before you paste the link into a cell in the new workbook.
To do this in Microsoft Windows XP, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem