Translated segments remain in the source language in target file

Question

Hi all, 
 I have translated a DOCX document in studio 2019. The translation in general came out fine, except for certain text boxes that remained in the source for no apparent reason. Certain other text boxes came out just fine. The ones that remained untranslated were text box objects in charts and those that were were independent text boxes. 
 What can be the reason for that in Studio? The text in these text boxes appeared in studio source and was translated, no error messages, how come the output file was in the source for these text boxes? 
 
 Thanks 
 Shmuel

Ana-Loredana Gabur · Answer

Hi Shmuel Pfeifel 
 
Maybe the below article would help 
 gateway.sdl.com/.../communityknowledge 
 
Best regards 
Loredana

Paul · Answer

Shmuel Pfeifel 
 Unknown said: Studio tells me that there are embedded worksheets or charts and that I should refresh the objects manually in the MS Word application 
 Perhaps the data in these objects has not been refreshed into the Word file ( linked rather than embedded ), in which case there is nothing Studio can do because there's nothing there. Studio can extract embedded Excel sheets and charts but there has to be data in them to see: 
 
 The message suggests you refresh so this should mean you simply open the file in Word and if you have access to where the data came from it should all update automatically. If you don't then you probably need to go back to your client with this question. 
 The article referred to earlier is almost three years old ;-)

Paul · Answer

Unknown said: Here's my text file, should anyone feel the urge to find out: 
 I just tested your file and see the problem. I googled this a little and can see a few people have problems with updating embedded Excel tables in Word so my immediate reaction would be that this is a Word refresh issue. I spent a little time trying to see if there was some setting that automatically refreshed embedded documents but could not find one... some ideas for macros that did this, but no setting. 
 I'll ask the question, but on the face of it I think this is a Word issue.

Paul · Answer

I also didn't notice, until now, that there is a warning in Studio (information message) when you save the target. It says: 
 
"Embedded Excel Worksheet or Chart detected. Refresh embedded object manually in the MS Word application." 
 
So the solution is in Word, and it would be good to know how to refresh all embedded objects in one go. I found this which also points to Word: 
 
 stackoverflow.com/.../automatically-update-formula-field-after-generating-open-xml-word-document

Trados Studio > 1. Trados Studio

Translated segments remain in the source language in target file