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: 04:57
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: 04:57
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: 19:57
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







LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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