Mobile menu

Problem with the clean up of file (.xls.ttx)
Thread poster: Sumana U

Sumana U
German to English
+ ...
Feb 20, 2008

Hi,

I am using Trados Version 8.0. Excel 2003.

I translated one Excel file using Translator's Workbench and TagEditor. I am not able to convert the bilingual file (.xls.ttx) back to Excel format. I am getting the message as shown below:


(-2147467259): Connection with server application error:
While renaming a sheet or chart, you entered an invalid name. Try one of the following:

• Make sure the name you entered does not exceed 31 characters.
• Make sure the name does not contain any of the following characters: : \ / ? * [ or ]
• Make sure you did not leave the name blank.
File skipped!


I entered a short file name, again translated it and tried to clean the file up.
The file name does not contain any of the following characters: : \ / ? * [ or ]
I did not leave any name blank.
The source (.xls) and the bilingual (xls.ttx) files are in the same folder with the same file name.
I have also selected the corresponding language pair termbase in Translator's Workbench.

I don't know how to clean the file up.
Please let me know if anyone knows the solution for this type of problem.


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 01:28
English to German
+ ...
Sheet name, not file name Feb 20, 2008

Hi,

(-2147467259): Connection with server application error:
While renaming a sheet or chart, you entered an invalid name. Try one of the following:

This does not refer to the file name - check your translation of sheet or chart descriptions. (Usually, this problem is caused by sheet names containing special characters - strictly speaking, not a Trados-related issue: AFAIK it's Excel that cannot handle these characters in sheet names.)

HTH, Ralf


Direct link Reply with quote
 

Jan Sundström  Identity Verified
Sweden
Local time: 01:28
English to Swedish
+ ...
Tabs in Excel Feb 21, 2008

Ralf Lemster wrote:

Hi,

(-2147467259): Connection with server application error:
While renaming a sheet or chart, you entered an invalid name. Try one of the following:

This does not refer to the file name - check your translation of sheet or chart descriptions. (Usually, this problem is caused by sheet names containing special characters - strictly speaking, not a Trados-related issue: AFAIK it's Excel that cannot handle these characters in sheet names.)

HTH, Ralf


Ralf is absolutely right. It's usually the tiny tabs in the bottom left corner of Excel that support very limited characters.
Try leaving those segments blank in TagEditor, or replace the content by QQQ, and you'll be able to edit them later if no other solution works.

/Jan

[Edited at 2008-02-21 13:53]


Direct link Reply with quote
 

Michel Mullejans  Identity Verified
United States
Local time: 16:28
Member (2006)
English to French
Thank you so much Ralf for this Excel pointer Aug 5, 2013

Thank you for helping us out. Much appreciated, Dear colleague!
Michel (Stayton, OR)


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Problem with the clean up of file (.xls.ttx)

Advanced search


Translation news related to SDL Trados





SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs