I have copied cells from Word documents and pasted in to Excel as Text Links by using paste-special.

The problem is that when the Docs are open the links are updating. but when they are closed, the valuse in the Excel change to #NAME?.

Any suggestions?