Studio 2011: "Failed to save target content. Unable to open Excel file..."
Thread poster: Robert Rietvelt

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
Feb 25, 2015

I translated an excel file (97-2003) with SDL 2011, and when I try to clean it back to excel, I get the message:

'Failed to save target content. Unable to open Excel file - it may be password protected'

And it may be not, because I had no problems translating it. I have to deliver in Excel, and I don't know what to do. Is there anybody who does?

Please let me know.


Direct link Reply with quote
 

Jean-Pierre Artigau
Canada
Local time: 07:44
English to French
+ ...
Suggestion Feb 25, 2015

One suggestion to by-pass this problem: update your main translation memory, then rename your source document and reload it as if you wanted to translate it again. All segments will be translated automatically from your translation memory. Then try to generate your target file from this translation.
This sometimes works.
Jean-Pierre


Direct link Reply with quote
 

Alicia Casal  Identity Verified
Argentina
Local time: 09:44
Member (2005)
English to Spanish
+ ...
Studio 2014 Feb 25, 2015

Maybe it helps: I use Studio 2014 and it's very similar to 2011.

Why did you try to "clean" it back to excel?

Alicia


Direct link Reply with quote
 

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
TOPIC STARTER
Clients wish Feb 25, 2015

I have to deliver in Excel, and the client doesn't work with SDL.

Direct link Reply with quote
 

Roy Oestensen  Identity Verified
Norway
Local time: 13:44
Member (2010)
English to Norwegian (Bokmal)
+ ...
Try running Verify Feb 25, 2015

I wonder if some tags may be misplaced. Try running Verify to check if there are tag problems (Review > Verify)

That you could import the Excel file into Studio does not prove that it is not read only, so that's no sure indication that everything is OK.


Direct link Reply with quote
 

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
TOPIC STARTER
Sorry, but.... Feb 25, 2015

tried all, but to no avail. Luckely I can copy and paste the translation, unfortunately not 1 on 1. Why? I don't know, the mystery of SDL, who is surprisingly silent.

Thank you for your input.


Direct link Reply with quote
 

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
TOPIC STARTER
Save target as Feb 27, 2015

I did some experimenting and opened another excel file, consisting out of multiple columns, in Studio 2011. The way Studio opened the file is strange on itself. It didn't put the text from up to down, but from left to right, so all columns are scrambled, and I lost the logical "overview" (need a printed version of the file to see what belongs where).

Furthermore, it splits up sentences that are in one field, and don't put them back when I save the target.

This, and my original question, are the problems I am facing. Anybody an idea?


Direct link Reply with quote
 

Dan Lucas  Identity Verified
United Kingdom
Local time: 12:44
Member (2014)
Japanese to English
Comments? Feb 27, 2015

Robert Rietvelt wrote:
This, and my original question, are the problems I am facing. Anybody an idea?

I know this is Studio 2011 rather than 2014, but could comments be the cause?

Dan


Direct link Reply with quote
 

Sandra& Kenneth  Identity Verified
Israel
Local time: 14:44
Member (2009)
French to English
+ ...
This may not a Studio problem - I had a similar issue (same error message) a few days ago in 2014... Feb 27, 2015

The Excel file may be corrupted. This file would not work in any Studio version on this computer, and I doubt that any other CAT can handle it either. Try saving it as a 2010 Excel first, if this doesn't work try repairing your Office installation, or even better, work on a spare computer using whatever version of Trados you have installed.
HTH,
Sandra


Direct link Reply with quote
 

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
TOPIC STARTER
Problem solved Mar 2, 2015

Worksheet name (WBS) source language - target language was different (I translated it). After changing it back, SDL cleaned my target file.

Direct link Reply with quote
 

Robert Rietvelt  Identity Verified
Local time: 13:44
Member (2006)
Spanish to Dutch
+ ...
TOPIC STARTER
Correction Mar 2, 2015

Problem half solved.

One file cleans, the other file not. So, my question is still open.


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 »

Studio 2011: "Failed to save target content. Unable to open Excel file..."

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 »
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