Hi and thanks for your reply, I am going to try your repair. I have noticed this is also true the other way round (if Word is a source document that I reference in Excel, I need the word document to be opened if I want the reference in Excel to work).Īny Ideas? (i have tried removing ALL add-ins in Excel, but that doesn't seem to resolve the issue.) Now the weirdest part: if I open the source file (in this case the excel spreadsheet), and manually update the broken links (Error! Not a valid link), they correctly update back to the correct values. The link gets updateds into an 'Error! Not a valid link'. Please insert the object directly into your file without creating a link'. To create a link to the object you specified.

However, if I go on a link a do a manual update (F9), I get the following error 'Word is unable To edit this object, install Excel or ensure that any dialog boxes in Excel are closed'.įurthermore, If I save, close and reopen my Word document, Word notices links (asks me if I want to update all the links, to which I answer 'Yes'). On your computer or it is not responding. If I try to right click the linked table, and select 'Linked Worksheet Object' and then 'Edit Link' or 'Open Link', I get the following error: 'The program used to create this object is Excel. The linked information will not be updated'. 'Objects in this document contain links to files that cannot be found. Now here is the problem: as soon as I close my Excel spreadsheet, and try to update my link in word, i get the following error message. (I've put both my windows side by side, and can see the values beeing updated as I'm working in my excel spreadsheet). If I update values in my excel spreadsheet, the values change in real-time in the word document.

Use the 'Paste Special' button in the toolbar, and paste as 'Paste link' in 'HTML Hello, I am having a problem with links to excel tables in word.

Cant keep source formatting word