Finalised excel file empty in 2007
Thread poster: Laura Morwood

Laura Morwood  Identity Verified
United Kingdom
Local time: 08:02
Member (2008)
English to Dutch
+ ...
Oct 12, 2011

Hi all,

I have finished a long translation in Trados 2007 and have finalised it. The original file is in Excel. When I try to open the finalised document, I get an error message saying "Excel found unreadable content in ..... Do you want to recover." When I click yes, my document is empty!

I also cannot generate a target view through tageditor. Error message reads " application error"

Apart from a lot of copy and paste, does anyone know a way around this problem?
Better still, can someone try and explain what the problem is?

Many thanks,


Direct link Reply with quote

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Local time: 15:02
Member (2004)
English to Thai
+ ...
Trados problems? Oct 12, 2011

I met many instances of this problem and I redo translation in Trados (e.g. TagEditor, SDLX or Studio 2009) to obtain the final Excel file. PC memory can be the cause of problem.

Soonthon Lupkitaro

Direct link Reply with quote

Martina-K  Identity Verified
Local time: 09:02
Italian to German
+ ...
No explanation for the problem, but... Oct 12, 2011

Dear Laura,

I cannot explain the Trados problem but would like to suggest the following work-around (if the excel file is not too complex):
1. Copy the original excel columns in a Word document.
2. Translate the Word document using the memory filled with your translation and clean it.
3. Paste the translated columns in the excel document.

This work-around still includes some copy-paste but is rather quick.

For the future, I would suggest that you create a ttx file from the xls/xlsx file, translate only one segment and immediately try to save as target. Unfortunately, many original files are unfit for translation and in this way you know from the beginning whether the file can be translated without any preparatory work. After quite a few bad surprises, I always test "save target" right in the beginning of a new project.


Direct link Reply with quote

Local time: 17:02
Russian to Japanese
+ ...
So, no difference between 2007 and 2009? Oct 12, 2011

I am about to get to a project which was provided in Excel...

Direct link Reply with quote

Laura Morwood  Identity Verified
United Kingdom
Local time: 08:02
Member (2008)
English to Dutch
+ ...
Thank you kind colleagues! Oct 13, 2011

Martina, thanks for the suggestion. It didn't work but I think the Excel file is just weird. I will certainly do a test in future before I do a whole translation, this has caused me no end of hassle!

Soonthon, thanks for your suggestion as well. I bought Trados 2009 a while ago and haven't got round to installing it. So that's what I've been doing today. It's never straight forward though...

Meanwhile, my agency has solved the problem at their end so I am eternally grateful.

With kind regards, Laura

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 »

Finalised excel file empty in 2007

Advanced search

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
  • Term search
  • Jobs
  • Forums
  • Multiple search