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

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
  • 0

    Hi Pia

    The issue is not with the name of the document - rather the name of the sheets in the Excel file.  Locate all the Sheet names in the SDLXLIFF file and make sure that they are under the 31 character limit for sheet names.  You can easily find the sheet names by clicking in the 'Worksheet' items on the browse panel:

    If you still have issues please attach the Excel file and SDLXLIFF file here so we can take a look.

    Thanks
    Fas

     

    Fas Aziz | Desktop Life Cycle Service Manager | SDL | Support Operations, Support Lifecycle

    emoji
  • 0 in reply to Fasil Aziz
    Hi,

    Thank you for taking time to help me with my problem. When I browse like you suggest it simply looks like the image that you have inserted, except for there being about 15 such worksheets. I can't see different names when I click them. And thank you for being willing to take a look at the document, but I can't send anything from a client to a third party. I keep all my texts confidential till they have been published. I have never encountered such problems before and I have worked in Studio for about 3 years. However, I have just changed over to Studio 2014 and seem to have quite a few problems in that connection.

    When I look at the different sheets/tabs in my source document, the longest name is something like this: 11. Input-output template 2 - nowhere near 31 characters.
  • 0 in reply to Pia Sander
    Email me your email\telephone number and we could have a quick look via remote session: faziz@sdl.com

    Thanks
    Fas

     

    Fas Aziz | Desktop Life Cycle Service Manager | SDL | Support Operations, Support Lifecycle

  • 0 in reply to Fasil Aziz
    Hi Fas,

    Thank you, but now it works. What I did was to make a new copy of my Excel document and just gave all the tabs/sheets a number. That means, of course, that I shall have to edit the tabs afterwards, but apparently you were right about the problem being the names of the tabs/sheets even though they were nowhere near the 31 characters.
  • 0 in reply to Pia Sander
    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 :-)

    Thanks
    Fas

     

    Fas Aziz | Desktop Life Cycle Service Manager | SDL | Support Operations, Support Lifecycle

  • 0 in reply to Fasil Aziz
    Hmm! Right now I am just happy that it works for me this way. I am not sure about the translation of the source name as it seems that I counted it as less than 31 characters. But thank you anyway. I really have to get on with this.
  • 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
  • 0 in reply to Walter Blaser
    Super. Thanks. I'll keep that in mind.