Tag Editor Error "The worksheet name uses imported data from an external source..."
Thread poster: LSGTranslations

LSGTranslations  Identity Verified
Argentina
Member (2010)
English to Spanish
+ ...
Oct 19, 2010

Hello, everyone. I'm working on a huge project using Tag Editor to translate Excel sheets and when I finished translating a 20k word document and tried to save the target file, I got the following error: "The worksheet name uses imported data from an external source, therefore the sheet name cannot be changed for the following sheet: module 1". I'm no expert in TRADOS, but I asked around and nobody has been able to help me with this. I'm working with TRADOS 2007. Please help! Thanks in advance.

Hola a todos. Estoy trabajando en un proyecto enorme utilizando Tag Editor para traducir hojas Excel y cuando terminé de traducir un documento de 20.000 palabras e intenté guardar el archivo target, me salió el siguiente error: "The worksheet name uses imported data from an external source, therefore the sheet name cannot be changed for the following sheet: module 1". Yo no soy experta en TRADOS, pero pregunté a varias personas y nadie ha sido capaz de ayudarme con esto. Estoy trabajando con TRADOS 2007. ¡Ayuda por favor! Gracias de antemano.


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 13:07
Member (2003)
Polish to German
+ ...
You are supposed NOT to translate worksheet names Oct 19, 2010

Use the search function in Tageditor
Search in tags for "sheet".
This will show yiu the worksheet names - when you find such tag, open the segment withing this tag and restore source for it (this simply means: leave worksheet names untranslated).
Do this for all WS-names.
After that your Excel file should save properly.


Direct link Reply with quote
 

LSGTranslations  Identity Verified
Argentina
Member (2010)
English to Spanish
+ ...
TOPIC STARTER
No segments found Oct 19, 2010

Thanks for your comment. Unfortunately, I couldn't solve my problem with this. I went to Edit, find (on Tag Editor) and searched in tags for "sheet" and the only thing that came up where two tags in grey (no segments there) with the word "worksheet". That's all I got. Any ideas? Thanks anyways.

Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 13:07
Member (2003)
Polish to German
+ ...
When you find the tag... Oct 19, 2010

Press ALT+HOME, it will open the segment.
When you see tag with the name "Worksheet", it starts the worksheet name - please just restore the names, which begin as segment with the "Worksheet" tag.


Direct link Reply with quote
 

LSGTranslations  Identity Verified
Argentina
Member (2010)
English to Spanish
+ ...
TOPIC STARTER
Problem solved! Oct 19, 2010

You are a life saver! Thank you so much for your help!

Direct link Reply with quote
 

Fernando Williams
Argentina
Local time: 08:07
English to Spanish
¡Gracias! Apr 14, 2011

I had this very same problem today and I worked it out thanks to your instructions, Jerzy. Thank you so much and thanks Mara for posting such a useful question!

Direct link Reply with quote
 

Malte Wendt
Netherlands
Local time: 13:07
Dutch to German
Thank you Jul 16, 2011

1000 karma-points for Jerzy!

Direct link Reply with quote
 

Louise Taggart  Identity Verified
United Kingdom
Local time: 12:07
Member (2008)
German to English
Thank you! Oct 12, 2011

I also just had this problem ... and your posting here has helped me tremendously.
Many thanks


Direct link Reply with quote
 

Lorena Vicente  Identity Verified
Argentina
Local time: 08:07
Member (2005)
English to Spanish
+ ...
Thanks Mar 17, 2012

Thank you, Jerzy!

I had the same problem today and was able to solve thanks to your suggestion.

Best,

Lorena


Direct link Reply with quote
 

Meritxell Ripollès  Identity Verified
Spain
Local time: 13:07
Bulgarian to Spanish
+ ...
Thanks a lot! May 14, 2012

Thank you! I had the same problem and had no idea how to solve it. Thanks to your comments I managed to deliver my translation on time

Direct link Reply with quote
 

Stacy Macaulay
Germany
Local time: 13:07
Member (2005)
German to English
+ ...
Still unresolved Jul 16, 2012

Hi there,

This is definitely a solid tip, but I seem to have a particularly difficult case on my hands right now with only hours until delivery of a huge file. I've read every single article out there on saving a TTX back to the original xlsx file, have tried everything and still have no idea why I keep getting the object reference message. The xlsx contains html code, but only in the cell text, which I am starting to suspect is the reason for this error. I have checked the sheet name and it was the same as the original, I even inserted it again to no avail though.

Of course, the original xlsx and the ttx are both in the same folder, I have also opened the TTX in notepad to verify that the original path is still there. I have definitely run out of options, due date in 6 hours and I leave on holidays an hour later!!!

I would sure appreciate some late night help on this one, it's a tough nut to crack this time.

Also, is there any way of salvaging the situation? I have a perfect TTX file, have also tried to clean the file with workbench with the same error message. Now my hands are tied and I'm pretty sure my client isn't going to be able to solve this situation either considering the utter complexity/the fact that it appears to be a unique case.

So if you have any enlightening thoughts I would more than grateful!

Thanks again,

Stace


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 »

Tag Editor Error "The worksheet name uses imported data from an external source..."

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 »



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