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?
Bookmarks