Hello,
I'm trying to insert text from an Excel 2010 file into a Word 2010 document using the "paste link" as an RTF. This works until the document is closed. When opening the the document, the 'update link' option is no longer available. When you right click and select 'object', a pop-up box indicates the object is "corrupt or no longer available".
I have multiple tables from the same Excel file "pasted as link" as an embedded Microsoft excel worksheet object, that do update correctly every time, so it's not the excel file. What I'm trying to do works with the text when pasting the link as an embedded Microsoft excel worksheet object, but I'd like to have this as text because using the worksheet object looks horrible from a presentation / formatting stance.
Any Suggestions?
Thanks.