Cannot save my document in Excel format

Question

Hello 
 
 I am working on a rather large document. The source file is an Excel document. I have no problem working in Studio with the translation, but when I try to save the target in Excel , I keep getting the same message that the name is longer than the allowed 31 characters and that I need to change the name. So, I changed the name, but that did not help me. Now I started all over, renaming the source document to checklist-eng, i.e. 13 characters! I opened a new single document for translation, filled it with the text from my TM, saved it and then tried to save the target as checklist-eng-da. No luck! Same message again. 
 
 Failed to save target content: The translated text length for the worksheet name is longer than the allowed 31 characters. Please change the text and try again. 
 
 Help!

Walter Blaser · Accepted Answer

Pia 
 
You can identify the worksheet names in your Editor by looking at the segments that have the ID "WSN+" in the last column. Their content should not exceed 31 characters and it happens often that users overlook this and simply translate the source text, with the result that the target segment gets longer than 31 characters. 
 
If you have other Excel sheets to translate in the future, you may control this behaviour by going to "Options - File Types - Microsoft Excel 2003-2013 - Worksheet name". It lets you choose how you want to deal with the worksheet names. If you do, for example, select "Do not translate sheet names", which often is convenient as customers often do not want us to change them anyway, you will not experience this problem again. 
You may also use one of the other options, depending on the requirements for the given job. 
 
Walter

Fasil Aziz · Answer

HI Pia 
 
The issue is not with the sheet names in the original source file but the length of the translation in the SDLXLIFF file :-) - so your original SDLXLIFF file probably ok - just the translated sheet names require truncating :-)

Trados Studio > 1. Trados Studio

Cannot save my document in Excel format