• State Verified Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 436 subscribers
  • Views 6044 views
  • Users 0 members are here
Options
Related

Cannot save my document in Excel format

Pia Sander

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! 
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply
  • 0 in reply to Pia Sander
    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
Children