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.


 

Ralf Lemster  Identity Verified
Germany
Local time: 06:33
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


 

Jan Sundström  Identity Verified
Sweden
Local time: 06:33
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]


 

Michel Mullejans  Identity Verified
United States
Local time: 21:33
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)


 


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







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

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

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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